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

Does the report refresh when you drill down?

Started by mel4363, 01 Oct 2014 02:49:31 AM

Previous topic - Next topic

mel4363

Hi Everyone,

I have a report with a prompt page with a few prompt controls, one of these are on accuracy (Textbox) that users may decide to insert, the default is 85.

I then defined a column chart with vehicle configuration class in Categories and Three calculated items in my series, the user can then drill-up/down on vehicle configuration class to see the value on different level (Vehicle makes, models, then registration numbers). My problem then comes in on this. The chart has to display based on accuracy (That is all vehicles with an accuracy of 85% or more or whatever value the user provided). This happens on the first run but once I drill-down on lower levels this filter doesn't seem to be active anymore. I keep getting vehicles with accuracy that do not meet the initial criteria.

My question then is what happens when you drill-down ? Are the filters refreshed or not ? if not how can I force this filter to be refreshed during a dril-down?


Thanks in advance

Mel