I have defined a Parent-Child hierarchy for one of my dimensions. (It is a flavour of organisation structure)
However, when I process it, each node repeats itself as one of its own children.
What is going on here and how can I fix this? Someone mentioned a property I can set, but nothing jumps out at me.
It's the datamember, no? If you drag and drop theses members for a MDX query it brings the .datamember in the end of the member? If so, just set to hidden the datamember.
The parent-child attribute has a property named "MemberWithData" set to "NonLeafDataHidden".
|||Handerson is right.
You have the change the default property to get the desired effect.
The default scenario which AS2005 is where a sales mgr and his salesmen all sell products and you wnat to display revenue for them.
The alternative might be that only the salesmen sell and the manager does not have any sales, Then you ahve to reconfigure the property defined above.
|||I don't understand what you guys are talking about... when I browse the hierarchy of my parent child relationship, for each parent node there is a child node with the same name and properties when the dimension is processed. This is before we even run any MDX...
|||Let's look a sample, if you have the parent-child dimension entity like that:
America|||Thanks for the clarification ... much appreciated.
No comments:
Post a Comment