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.
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.
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.