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

Filter some members in a measure and display parent level

Started by Mr.Cognos, 05 Apr 2017 01:58:23 PM

Previous topic - Next topic

Mr.Cognos

Hello all,

I have one dimension with 2 levels and for example my data is:






DIMENSIONMEASURE
01 - CHANNEL10
*01 - TELEPHONE4
*02 - INTERNET6

Level 1: 01- CHANNEL, Level 2: 01 - TELEPHONE, 02 - INTERNET

I would like to filter my crosstab for example by 01 - TELEPHONE and show only parent level, something like:




DIMENSIONMEASURE
01 - CHANNEL4

But my result is always:





DIMENSIONMEASURE
01 - CHANNEL10

How I could filter some members for the dimension and show the value filtered in the parent level or rootmember?


Thanks