Hey. I'm trying to dynamically change the measure in my chart. I've put Query Calculation object as a Default Measure in chart (with if/else statement inside). However it seems that in Query's expression I can use only values from source, data items, functions etc. How can I extract the value from Active Report variable (it is set by button click)? Do I have to to create some transitional data item? Any help very much appreciated...
Hi,
Is this within an Active Report? If so, what you are attempting to do is not possible as things stand today (30th May 2013). Charts in Active Reports in Cognos 10.2 are pre-rendered when the MHT file is created and are stored in the MHT as static images. This means there is no way you can dynamically change the type or content of a chart when using the active report MHT in your browser or iPad app. Instead, you need to take a different approach. Use a Deck in your report with a number of cards - one card for each measure you would want to use in your chart. Drag a chart onto each card and populate the chart with the relevant measure for that card. Then add a control (a radio button group, for example) with values that correspond to the cards on your deck. Finally, link the control to the deck using a variable.
Cheers!
MF.