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

Multi-select measure in graph

Started by oscarca, 08 Jul 2019 08:14:14 AM

Previous topic - Next topic

oscarca

Hello,

Is it possible to create measure prompt that lets you choose multiple measures in a graph on the x-axis. Lets say you have a bar chart where each bar is a measure and you wish to dynamically choose one or more measures to compare next to each other.


Best regards,
Oscar

BigChris

You might have to create multiple graphs and just render the one you want to display.

oscarca

#2
I need the measures to be their own bar though in the same chart for example One bar for Actuals and one bar for Budget next to each other.

I tried with this syntax and placing it in the measures field in the bar chart but for some reason all the parameters disapear from the drill-through definition:

set(#promptmany('pMeasure','token')#)

oscarca

#3
I acutally solved it by adding a defaultvalue in the prompt macro.
set(#promptmany('pMeasure','token','[Measure].[Measure],[Actual])#) and using the same MUN as default selection in the value prompt. If no default selection were made, the main report couldn't find the parameters to connect to. After that using MUN as use value in static choice. For some reason it did not work to use MUN instead of token in the prompt macro.

CognosPaul

Nice, that's exactly how I would do it. The reason mun didn't work is because measures aren't considered member unique names, so the validation fails on them.

The issue with parameters disappearing when building drillthroughs is annoying, sometimes I resort to making a first page that has all of the parameters I need, defining the drillthrough in the source report, then removing the dummy page from the target.

oscarca

I was actually looking at one of your old blog posts about prompt macro tokens, which was very useful. That is exactly what I thoughts aswell, since the report kept giving me Unresolved prompt "Unknown format" error. There is probably a logical reason why the parameters disappear sometimes Deep down in the binary World hehe. That is a nice way to get around that issue Paul. I should try that whenever I stumble abown it. I usually just create a data item, where I then place the parameter inside and place it in the report and then hiding it.