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

Active report - interactivity to KPI

Started by donut, 14 May 2024 07:12:13 AM

Previous topic - Next topic

donut

It's me again, the dumbo asking active report questions :-S

I believe it is common to have KPI presented in dashboard. In Cognos report, the most common object used is called "Singleton" where a "text item" is embedded in it, and we can switch to use data item value. In active report, it seems impossible to filter/select a singleton, can anyone confirm this?

As an alternative, I switched to use "list" object, which seems to be the second most promising way. But a list shows multiple lines when multiple items are picked using active report checkbox. I tried hiding the categorical column using "box type" properties, made that column "hidden", remove the categorical column from the list and add into the list's properties, even played with the aggregation settings, but nothing works - still shows multiple line :(

Left with two not so decent options -
1) Change the font of the list to super small (0.1 pt) and do a total for the list with normal font
2) Attempt crosstab

Appreciate for any input :)