Hi,
I have two, I think related requirements for a report based on an SSAS OLAP Cube and a Parent-Child dimension:
1: I need to be able to filter a dataset to bring back the children of a parameter value while EXCLUDING the parent itself.
2: I need to be able to filter a dataset to bring back the DATAMEMBER of the parent (so just its own data, excluding the children)
I have created a data item (called Parent) with the definition:
[Spend and Savings].[Customer Dimension].[Parent Key] -> ?Department?
- with a second data item (called Children) with the definition:
descendants([Parent],4,before)
- I think I need some way of filtering the Children data itme but I am just chasing my tail with various functions and macros trying to do this dynamically and getting nowhere. If anybody can assist it would be greatly appreciated.
David