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 out member on one level display another in crosstab

Started by Deep750, 22 Mar 2017 10:54:36 AM

Previous topic - Next topic

Deep750

Hi,
My source is dynamic cubes.
I have a requirement where I have a crosstab with two measures.
I have to filter the two measure against two different dimensions, but display one of the dimensions in the crosstab.

I am able to exclude the member by using except()-function. The member i'm excluding is on level two. The issue is that I need to display level one on the rows, in the cross tab.
I can't use slicer, as only one measure should be filtered by it. To get the except-function to work, I have to use descendants()-function to get the level on the same level as the member i'm excluding - isn't it?

To complicate it further, the exclusion is done on a macroprompt. exclusion works, but i'm not able to display the filtered dimension in the report, for level one, in the hierarchy.

Do you have any suggestions on how to solve it?