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

exclude a member in a tree prompt hierarchy

Started by MatCramo, 11 Sep 2014 02:05:21 AM

Previous topic - Next topic

MatCramo

Hi. I have a tree prompt in a report:
Country level (1)
   region a (level 2)
   region b (level 2)
   region c (level 2)
   etc..

I want to show the hierarchy with Country level 1 on top and the users should be able to choose within the tree prompt. Whole country or just one or more regions.
Now i want to exclude one of the regions in the report:
Country level (level 1)
   region a (level 2)
   region c (level 2).
How can this be done?


/M

bdbits

Put a filter on the query used to populate the prompt.