Hello.

I have problem with using attributes on hierarchy dimention
I need build dimension on DateSourceTable

DimSourceTable is (isn, Contract, City, ShopID)
({F48E60D0-C29A-433D-8C67-75965CA20D19}, 'AAA', 'MOS', 'AA1')
({11AC4566-EBD4-4B6F-B6F5-CD895DAF2117}, 'AAA', 'SPB', 'AA2')
({0D90808F-7868-4C5A-A2FC-D5C9EB477D91}, 'BBB', 'SPB', 'AA3')

I want to create hierarchy Contract -> City and ShopID should be attibute on city level
I expect to browse follow hierarchy
AAA
But, receive ...

AAA
P.S. I'm using SSAS 2005 with SP1

Thanks.

Hi,
From your description, I understand that:
You want to create parent-child hierarchy between Contract and
(City,ShopID).
If I have misunderstood, please let me know.

You can configure such parent-child hierarchies according to:
Creating a Parent-Child Hierarchy
http://msdn2.microsoft.com/en-us/library/ms174598.aspx
Configuring Parent-Child Hierarchies
http://msdn2.microsoft.com/en-us/library/ms174592.aspx

Also, you can refer to SQL Books Online Analysis Services Tutorials Lesson
3 and 4. They are more detailed.

If you have any other questions or concerns, please feel free to let me
know. It's my pleasure to be of assistance.

Charles Wang
Microsoft Online Community Support

================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====

Probaby your city key is not unique. You could use collection keys contract
and city for your city key column

"Sergey Popov" wrote:

Hi,

Just checking in to see if the suggestions were helpful. Please let us know
if you would like further assistance.

Have a great day!

Charles Wang
Microsoft Online Community Support