Changing Attribute Label Name in a Shared Dimension

Hi,

I have a dimension called Branch that is linked to alot of Branch-related fields in my fact table like Send-To Branch, Collection Branch, Receiving Branch etc.

Since my Branch dimension is shared, if i change the description name of my attribute in Send-To Branch Dimension Structure, it will affect the rest of my Dimensions related to Branch. Can it be possible that i can change the attribute name in each branch dimension without affecting the others?

example:

Send-To Branch

Send-To Branch ID

Send-ToBranch

Send-To Branch Type

Collection Branch

Collection Branch ID

Collection Branch

Collection Branch Type

cherriesh

No, It is not possible to rename attributes in each instance of a role playing dimension.|||

So that means, I need to create SQL views to instantiate my Branch Dimension and link them individually to the different branch-related foreign keys in my fact table?

is it too costly in terms of the storage?

cherriesh

|||

Well it either means that you need to come up with a more generic naming convention for your attributes. So that your cube dimensions would look something like the following...

Send-To Branch

Branch ID

Branch

Branch Type

Collection Branch

Branch ID

Branch

Branch Type

Although this is not without issues as it can be confusing in tools like Excel where you cannot always tell which dimension an attribute came from.

I don't know if you need to create SQL views, you might be able to get away with creating multiple identical dimensions off the same dimension table(s). I'm not sure as I usually use the generic attribute name approach.

It is not usually too costly in terms of disk storage as most dimensions are pretty small when compared to the fact tables. It can have an impact when you consider cache storage as SSAS will be caching multiple sets of identical dimension keys which it does not need to do with role playing dimensions. You will also have to consider the extra processing time and the maintenance overhead of having to keep multiple dimensions synchronized.

Change Unc Path On Sql

I have a question on how to change a hyperlink path. I have an ADP that has our scanned files linked to it the path is on SQL server. The problems is that we are migrating sql server and the files to their own seperate server,
\\gcfs01\database\Backgrounds\SCANNED ACROBAT DOCUMENTS (BACKGROUNDS)\SCANNED ACTIVE FILES\5630.pdf

The server is called \\gcfsql\ Instead of gcfs01.
does anyone know how we can change the unc path to gcfsql without

\\gcfsQL\database\Backgrounds\SCANNED ACROBAT DOCUMENTS (BACKGROUNDS)\SCANNED ACTIVE FILES\5630.pdf

Any help would be greatly appreciatedNot sure I understand the question fully. Do you mean you have a bunch of UNC paths stored in a table and you want to update the server name in each path?

If so, you could do something like this:

update mytable set path = replace(path,'\\oldserver\','\\newserver\')|||See the thing is that we have about over 2000 employees who get an employee number and their file is saved in the old server as their number
and the only thing we need to change is the destination server the rest is fine but I dont want to mess anything up. Know what I mean, so I'm asking the Gurus :)|||Run Jezemine's replace statement as a select to see what it produces. Unless any of your employees have "\\" in their filenames, it should give you what you want.|||update EmployeeDocuments set EmployeeDocs = replace(\\gcfs01\database\Backgrounds\SCANNED ACROBAT DOCUMENTS (BACKGROUNDS)\SCANNED ACTIVE FILES,'\\gcfs01\','\\gcsql\')|||no, don't run that. it will update every record with the same value. certainly not what you want. you want this:

update EmployeeDocuments set EmployeeDocs = replace(EmployeeDocs,'\\gcfs01\','\\gcsql\')|||You realize this goes against Normalization. In a disaster recovery situation, you may be saddled with this breaking again - just when you least have time for it. Or you may want to create a test environment and wind up with someone updating the production employee records.

Things like "where we keep stuff" and "the servername we keep it on" should be in a central place and never hard coded into "each employee's record" - unless that can be different for different groups of employees.

A little late to fix, but something to file away in the brain for the next time this sort of design decision arises.|||Thats exactly what I did and it worked.

first I changed the ntext data type to nvchar(300)
and it worked .

Thank you guys worked like a charm|||its just that we are changing servers thats all and we wanted to change the path from the old server to the new server thats all.

Change password in ODBC..?

Hi all,
I have an Access appl. with linked SQL-server tables.
The user have a SQL-server login from a ODBC datasource.
How can I get the user to change password themselves after a temporary
password?
Kent J.
Hi Kent,
I am not sure if I understand the problem but, if the password of the login
was changed on SQL Server, then you will need to find the ODBC Data Source
Name and update its password too. Go to Control Panel, Adminstrative Tools
and Data Sources (ODBC).
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Kent J" wrote:

> Hi all,
> I have an Access appl. with linked SQL-server tables.
> The user have a SQL-server login from a ODBC datasource.
> How can I get the user to change password themselves after a temporary
> password?
> Kent J.
>

Change password in ODBC..?

Hi all,
I have an Access appl. with linked SQL-server tables.
The user have a SQL-server login from a ODBC datasource.
How can I get the user to change password themselves after a temporary
password?
Kent J.Hi Kent,
I am not sure if I understand the problem but, if the password of the login
was changed on SQL Server, then you will need to find the ODBC Data Source
Name and update its password too. Go to Control Panel, Adminstrative Tools
and Data Sources (ODBC).
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Kent J" wrote:

> Hi all,
> I have an Access appl. with linked SQL-server tables.
> The user have a SQL-server login from a ODBC datasource.
> How can I get the user to change password themselves after a temporary
> password?
> Kent J.
>