COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Active Reports => Topic started by: reneincer on 19 Nov 2013 12:25:59 PM

Title: Filter Chart on List with Calculated Member
Post by: reneincer on 19 Nov 2013 12:25:59 PM
Hi there,
I have a calculated member, and a set with many items including the calculated member,

I have a list with this set, and a chart for each Item, with Master Relation Ship, because Chart does not allow to filter, so I link the set from List to Chart,  the list filters all items except the calculated member,

Do you know if i'am doing something wrong or chart does not allow to filter with calculated member on Master Detail Relationship?
Title: Re: Filter Chart on List with Calculated Member
Post by: CognAsh on 21 Nov 2013 05:28:27 AM
Hi,

I'm not sure if I understand correctly. Are you trying to FILTER a chart? If this is the case then you cannot do this as charts are rendered at build time and there is not client side charting engine.

What you need to do is create a deck with a card for each of your filters then master-detail the chart to the card. Create a control that selects the necessary card.

For example. If you have products ABCDE and you want to show a chart per product, then create a deck with cards A,B,C,D,E and put a chart on each card. Master-detail the chart to the card (to filter the chart to the relevant product) then create a button bar with buttons A,B,C,D,E. Click button A will show card A which will have a chart filtered on product A.

Hope this helps.

Ash