I have a dimension attribute that describes a self referential hiearchy in the dimension. I have this setup and working with one exception. When I use this hierarchy I only want members which have children to be displayed at each level instead of all members regardless of whether they have children. How do I do this?
Thanks,
Chris
If you don't display childless members at each level, where would they go? Aren't they leaf members, just at a higher level in the dimension based on their parents?
Not sure I understand why you would want to hide any members. Can you give an example or some more details?
Dave Fackler
I have a DIM_Customer with a Referred_By_Customer_Key, which stores a value if a particular customer happens to be referred by another customer, otherwise, NULL is stored.
Wizard auto detected that this is a Parent-Child hierarchy as it was a FK to its own PK.
When browsing the Dimension, it is showing
Parent Customer -> Referred Customer Level 1 -> Referred Customer Level 2...
However, a lot of customers havent referred anyone and are having 0 children in the hierarchy. How could these customers be hidden from view?
Using a regular attribute hierarchy seems easier to achieve this. I cannot figure out for Parent-Child.
