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

Passing a parameter to drill target without using it in a chart?

Started by hrk551, 23 Nov 2010 11:16:14 AM

Previous topic - Next topic

hrk551

Hi


In a chart I am showing Month VS Amount and I am filtering only 'A' Flag projetcs in this chart query.

In a drill Target I have a 2 prompts 1) Month, 2) Flag : ('A' and 'E')

Now is there a way where I can pass  Month along with flag 'A' from the chart to drill target with out using flag in the chart.

rockytopmark

Create a data item in the query, with expression = 'A'
Then on the Chart's axis that is drilled on, set properties to include this new data item
Last, set the drill through on the Flag parameter to use the new data item

Setting the properties in effect tells Cognos to include the data item in the request, and the value in the SQL resultset, even though it isn't used in generating the graph.

hrk551


Thanx for the reply,

This worked for me, now I have a added question to this- Now we have got one more flag added to it (A,E,N). Here by adding the data item in the property I am able to pass only one flag, i want to pass multiple flags at a time.  Multiselect function in my drill target is working fine, only thing is when I pass from the chart only 'A' is passing. How can I pass multiple.