COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Active Reports => Topic started by: Richard1977 on 22 Sep 2017 05:41:46 AM

Title: Filtering for Charts
Post by: Richard1977 on 22 Sep 2017 05:41:46 AM
Good Morning
I wonder if anyone can answer a I have about active reports.

I am a report developer using report studio for many years but I am currently designing my first active report, I want to be able to filter numerous items by a data radio check buttons. I have set all the lists to be controlled by them and they work fine, however somebody has asked me to include a couple of charts. I have added them but the issue is when I try create a connection between the radio buttons and the charts, it only offers me the select option

So my question is can you filter charts the same way you can lists?

Many thanks in advance for any help

Regards
Richard
Title: Re: Filtering for Charts
Post by: hespora on 22 Sep 2017 06:43:44 AM
No, you cannot. There's two things you can do:

a) ditch charts in favor of visualizations.
b) stick a chart inside a data deck and setup master-detail relationship. controls *select* rather than filter the data deck's cards, which show different versions of the chart, which in turn looks like filtering.
Title: Re: Filtering for Charts
Post by: Lynn on 25 Sep 2017 02:59:20 AM
Hespora is on the money with those two options.

If you go with option "b" and have many different versions of charts, you may find the overall size of the MHT to be larger than desirable. There is no charting engine for traditional charts, so each possible iteration will be pre-rendered (as an image) in the file. If there are only a couple possible chart displays then this is less of an issue.

Option "a" will load the visualization engine, which is a small overhead, but than many different visualizations with numerous filter options can be included with much less impact on the overall file size. As an added bonus, visualizations have animation properties which allows for a more appealing user experience.
Title: Re: Filtering for Charts
Post by: Richard1977 on 25 Sep 2017 11:04:43 AM
Thank you Lynn and Hespora for your options.

I will try these option A because the active report will have several charts that need filtering, so size may be an issue

Thank you again for your help