COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Manu0521 on 03 Apr 2014 12:50:47 PM

Title: Filter data and show in prompt
Post by: Manu0521 on 03 Apr 2014 12:50:47 PM
I have to show customers in a prompt based on specific regions. I dont want to use a detail filter. What should i expression be to achieve this.
Some thing like sacustomers  from east region where customer is a level and east is a higher level.

If I have two prompts in my report which i use only for filtering the data and I dont show it in rows or columns. How can my slicer condition be..will it allow me to give two conditions in my slicer.?

Thanks,
Title: Re: Filter data and show in prompt
Post by: MFGF on 04 Apr 2014 09:12:39 AM
Quote from: Manu0521 on 03 Apr 2014 12:50:47 PM
I have to show customers in a prompt based on specific regions. I dont want to use a detail filter. What should i expression be to achieve this.
Some thing like sacustomers  from east region where customer is a level and east is a higher level.

If I have two prompts in my report which i use only for filtering the data and I dont show it in rows or columns. How can my slicer condition be..will it allow me to give two conditions in my slicer.?

Thanks,

Hi,

So you want to show countries within a specific region in your prompt? How is the region determined? If it's a fixed member, then the "use value" of your prompt would be a calculated expression such as

descendants([Your chosen region member], [Your countries level])

If you are prompting for the region also, then the expression would be

descendants([Your region hierarchy or level] -> ?YourRegionParameter?, [Your countries level])

The first part of this is driven by the expression you originally used to generate the Region prompt - could be the hierarchy or the level, or even something different.

MF.