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

How to see what was selected in a value prompt?

Started by longhorndkr, 30 Jul 2013 11:03:11 AM

Previous topic - Next topic

longhorndkr

If I have a line graph (chart) with 3 measures going across -- basically 3 lines -- by time frame (categories at bottom), how can I tell which measure (which line) was selected?  How can I see the value that was passed to the value prompt?

calson33

Put a text item on your report and change the source to report expression. Then make the expression point to a parameter (3rd tab).

longhorndkr

Well, my problem is that my chart is calling a drill-through report with a crosstab on it.  I've tried adding many text items to the Parent chart report as you suggest but they will not display because the dang thing opens the drill-thru after they select a hotspot on the chart and never fills in the text boxes.  If I disable the drill-thru I won't be able to see what they selected in the chart, will I?  The hotspots will be deactivated?

calson33

Put the text items on the drill through - That way you can see what has been passed to it.

longhorndkr

Hi Calson33,

The text item on the Target (crosstab) report is coming up blank--or I'm being prompted for a value--that's why I want to know to know what value is actually being passed!  ;)

Can you think of another way to see it?  I basically am getting all but the dang name/caption of the Measure that is being selected in the chart. 

It looks like I get the number/measure value instead of the measure name so I changed the paramter in drill-thru defs to pass the Member Caption instead of the Data Value but it keeps passing a number as far as I can tell.  Could there be some cache that I can clear? 

Thanks for all the help!

calson33

I am afraid I don't have any other ideas  :-\

Maybe redo your drill through definition to see if that is the problem?