If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Complex filter on Parent-Child dimension

Started by Revelator80, 25 Nov 2013 04:28:57 AM

Previous topic - Next topic

Revelator80

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