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. The "Category Name" and "Sub-Category Name" levels should be hidden in the hierarchy if either of them is blank. Leaf nodes which always have a value must display even if these two levels are blank.

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

Measure dimension

I thought using HideMemberIf would fix this problem but it hasn't made any difference. Here is the Translations configuration:

Dimension translations

According to MSDN, HideMemberIf with a NoName value hides the member when it is empty. http://msdn.microsoft.com/en-us/library/ms129445(SQL.90).aspx

Any ideas why this isn't working?

sql-server-2005ssasolap
10 |1200

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

Derek Comingore avatar image
Derek Comingore answered

Have you ensured the MDX Compatability property is set to 2 in the client connect string?

See here for more info: http://technet.microsoft.com/en-us/library/ms365406.aspx

DC

10 |1200

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

Rob Farley avatar image
Rob Farley answered

Why are you doing this in the translations tab, rather than the main Dimension tab?

1 comment
10 |1200

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

@Rob Farley: I'm just learning this stuff so may well have it completely wrong. Can you be more specific?
0 Likes 0 ·

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.