Print Page - exclude a member in a tree prompt hierarchy

Title: exclude a member in a tree prompt hierarchy
Post by: MatCramo on 11 Sep 2014 02:05:21 AM

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

Title: Re: exclude a member in a tree prompt hierarchy
Post by: bdbits on 11 Sep 2014 11:27:51 AM

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: MatCramo on 11 Sep 2014 02:05:21 AM