Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: DeepthiSP on 04 Jul 2018 06:01:39 AM

Title: Applying Filters in drill down hierarchy at a specific level
Post by: DeepthiSP on 04 Jul 2018 06:01:39 AM

I have a report with 4 levels of drill down ex: Region -> Country -> State -> City

When I apply filters (value prompt) in 3rd level which is "State" in this example, report is taking me to 1st Level (Region) and i need to drill down to "State" to see the results. Is there anyway to display the report at the level which we apply filters rather displaying from the 1st level of hierarchy. Please suggest.
Note:We are using version Cognos10.2.2 Version
Title: Re: Applying Filters in drill down hierarchy at a specific level
Post by: sdf on 12 Jul 2018 10:15:40 PM
use prompt macro. this will let you choose the level on the hierarchy you want to display base on your prompt.
Text only | Text with Images