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

Applying Filters in drill down hierarchy at a specific level

Started by DeepthiSP, 04 Jul 2018 06:01:39 AM

Previous topic - Next topic

DeepthiSP


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

sdf

use prompt macro. this will let you choose the level on the hierarchy you want to display base on your prompt.