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

Updating Parameter to DataValue

Started by yossiea, 04 Nov 2013 11:42:18 AM

Previous topic - Next topic

yossiea

Hi,
I have a dynamic drill-through report where the "main column" is based on a variable, so a user can decide how they want to group the data.
(World, Continent, Country, State)
I want to be able to then click from W>C>C>S. I can do that fine, however, the query does not store the existing data and when I click from one level to the next, it will not be filtered.
I then decided to create a filter where if it's level Country, then filter on Selection, so I will get the correct continent, but when I click on the country, I will get all records for that level, and it won't be filtered by the upper level i.e. continent.
I tried to set the filter at run time but it doesn't work.
I tried (if level = country, then continent = selection (what you clicked on) but Cognos ignores that.
Is there any way to have the parameters updated to a data item?

Thanks a bunch.

yossiea

Much simpler:

I have a filter on my query: Continent = ?d?
I have a report that loads data.
When I click on the data, it passes that to the drill through.

I want to set ?d? to be that item, so that when I run the drill-through again, it retains that variable.