question

Alex Angas avatar image
Alex Angas asked

Problems creating ragged hierarchy with Analysis Services

I'm attempting to create a ragged hierarchy in SSAS 2005. In this cube, the "Category Name" and "Sub-Category Name" levels should be hidden in the hierarchy if either of them is blank.

An image of how the measure has been configured is as follows:

http://img39.imageshack.us/img39/9468/dimmeasuretrim.png

According to MSDN, setting HideMemberIf with a NoName value hides the member when it is empty. Unfortunately this hasn't made any difference.

Any ideas why this isn't working?

sql-server-2005ssas
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.