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:
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?