I have the following dimension in AS2005

SurveyType
QuestionType
QuestionPosition
QuestionSub

QuestionSub is the lowest level and designated as the key. I am using the
Primary Key of the table (need it to join back to the fact), but want the
Dimension to display and rollup the non-unique names...I get multiple members
with the same name at the lowest level...what settings should I use to
eliminate this?

Thanks!

Can you post an example of what you are currently seeing and what you
would like to see?

It's possible that you may need to add another, lower level attribute to
use as the key attribute.

--
Regards
Darren Gosbell - SQL Server MVP
Blog: http://www.geekswithblogs.net/darrengosbell

In article <8C9DE31D-25B4-44A3-A41A-F2D87E77AF54 (AT) microsoft (DOT) com>,
JeanineCarroll (AT) discussions (DOT) microsoft.com says...

This is what I see:

End of Term
Teaching
Question 23
1
1
1
2
2
2
3
3
3

Where the lowest level 1,2,3 is the name associated with different primary
key..i.e. each 1, 2 and 3 has a different primary key that is used to join
back to the fact table.

I would like to see:

End of Term
Teaching
Question 23
1
2
3

Where regardless of the key, the names are grouped.

Thanks for the response Darren!

"Darren Gosbell" wrote: