I'm trying to configure a ragged hierarchy on a product dimension in SSAS 2008:
Some products don't have a 2nd sub category so on the Product Hierarchy I have set the level property 'HideMemberIf' to be 'ParentName' (and also tried 'OnlyChildWithParentName')
This works in SSMS and I can expand the nodes and see details where I'd expect too. However when I drag the product name onto the grid it only shows for those rows where there is a second category; i.e. it seems that the HideMemberIf property affects the whole row, not just the individual level.
Is this expected?
Thanks for your help,
View Complete Post