Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  NEWBIE DimensionAttribute vs new Dimension

Author  Topic  wilberw Starting Member 1 Post Posted - 2009-02-02 : 06:31:27 I am using SSAS 2005 but I am confused because there appears to be two different ways of doing the same thing. I have a dimension dimWORKER which I now wish to query by gender. I added the table GENDER (Id INT, Name NVARCHAR) ~ related to the table WORKER via GenderId (INT) ~ to the data source view. At this point I can create a new dimension (dimGENDER) and link it to my measure groups in the Dimension Usage tab. Alternatively, I can add Gender Id and Gender Name as DimensionAttribute(s) to the existing dimWORKER dimension. I would be grateful if someone could explain the difference between the two options and what is the best practice. Many thanks