Dear All Cognos Gurus,
i have a requirement to create a report with 1 chart with the series checkbox item. When we tick the checkbox the chart will add a series with a different type of series type (bar, line, etc).
Can we achieve this requirement using active report? if yes, kindly help to give the tutorial or document related this.
really your help..thanks a lot.. :)
Cheers,
Ken
Quote from: kenrisen on 06 Feb 2015 11:38:15 AM
Dear All Cognos Gurus,
i have a requirement to create a report with 1 chart with the series checkbox item. When we tick the checkbox the chart will add a series with a different type of series type (bar, line, etc).
Can we achieve this requirement using active report? if yes, kindly help to give the tutorial or document related this.
really your help..thanks a lot.. :)
Cheers,
Ken
Hi,
You would achieve this using a deck and a check box group (or, more probably, a radio button group since you only want to select one type at a time). You define one card in the deck for each series type you want to use (line, bar, column etc) and name the radio button group items in exactly the same way. On the line card of the deck, drag in a chart with a line series. On the bar card of the deck, drag in a chart with a bar series etc. Finally, create a link between the radio button group and the deck based on a variable - the radio button group should SELECT the deck.
Cheers!
MF.
Hi MF,
Thanks for your fast response.. :)
do you have any sample or tutorial?because this is my first time using active report.
Cheers,
Ken
Quote from: kenrisen on 07 Feb 2015 04:13:25 AM
Hi MF,
Thanks for your fast response.. :)
do you have any sample or tutorial?because this is my first time using active report.
Cheers,
Ken
I attached a report spec of a working example so you could see how I did it. :)
MF.
Hi MF,
May I know the package that you use? go data warehouse (analysis) or (query) or go sales (analysis) or (query)?
And do you have a sample with the checkbox?
cheers,
Ken
Hi MF,
If i'm not wrong, the sample you gave is a report that have a feature for user to choose which chart they want use to see the data, is it correct?
how about if i want 1 chart but the user have ability to add or subtract the series item in the chart. For example the default chart will show a sales, cost, and net income (the checkbox has 3 items : sales, cost and net income ; all 3 items checked). If the users just want see sales and cost value, they just unticked the net income item in the checkbox.
Can we create a report like that?
Cheers,
Ken
Quote from: kenrisen on 07 Feb 2015 05:50:08 AM
Hi MF,
May I know the package that you use? go data warehouse (analysis) or (query) or go sales (analysis) or (query)?
And do you have a sample with the checkbox?
cheers,
Ken
Hi,
I used the sample "Great Outdoors Sales En" package, which is based on the sample PowerPlay cube. It would work in exactly the same way with any package though - the data isn't important, it's the way the Active Reports controls are used and link together.
Quote from: kenrisen on 07 Feb 2015 06:19:53 AM
Hi MF,
If i'm not wrong, the sample you gave is a report that have a feature for user to choose which chart they want use to see the data, is it correct?
Yes - the user picks a chart type using the radio buttons. All the charts contain the same data.
Quote from: kenrisen on 07 Feb 2015 06:19:53 AM
how about if i want 1 chart but the user have ability to add or subtract the series item in the chart. For example the default chart will show a sales, cost, and net income (the checkbox has 3 items : sales, cost and net income ; all 3 items checked). If the users just want see sales and cost value, they just unticked the net income item in the checkbox.
Can we create a report like that?
Cheers,
Ken
Sadly not. This would require filtering, and charts cannot be filtered in an active report because there is no embedded chart engine in the MHT to re-render charts. The charts are pre-rendered as the MHT is created, and are stored as static png images in the MHT. The controls allow you to navigate from one card of a deck to another to show different pre-rendered charts on each card, but you can only show one card of a deck at any one moment in time.
If you have Cognos 10.2.1 or later, you do have the option of using visualizations instead of charts in your active report. Unlike charts, these are rendered interactively within the MHT (the visualization engine is held within the rendered MHT to allow re-rendering of visualizations on-the-fly). This means you can filter the chart series based on checkboxes, and since you are filtering it would allow you to show any combinations selected.
Do you have 10.2.1 or later? If so I will put together an example using a visualization.
MF.
Hi MF,
Thanks for your response and update.:)
I have plan to upgrade the system to 10.2.1 before this activity, could you give me guidance to achieve that report?
Best Regards,
Ken
Quote from: kenrisen on 10 Feb 2015 08:54:45 PM
Hi MF,
Thanks for your response and update.:)
I have plan to upgrade the system to 10.2.1 before this activity, could you give me guidance to achieve that report?
Best Regards,
Ken
Here's an example of a report with a data checkbox group filtering the series of a clustered column visualization.
MF.
Quote from: MFGF on 11 Feb 2015 08:13:50 AM
Here's an example of a report with a data checkbox group filtering the series of a clustered column visualization.
MF.
Hi MF,
thanks for the sample, will try as soon as possible after the upgrade version activity complete.
Cheers,
Ken
Quote from: kenrisen on 11 Feb 2015 07:57:00 PM
Hi MF,
thanks for the sample, will try as soon as possible after the upgrade version activity complete.
Cheers,
Ken
I wrote the example in 10.2.2 - you might as well go to that version if you can?
Good luck!
MF.