COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Active Reports => Topic started by: cognos05 on 15 Aug 2014 10:41:08 AM

Title: Data Radio Button and Column Chart
Post by: cognos05 on 15 Aug 2014 10:41:08 AM

Hi All,

I have a data radio button group showing different products.

I want to have a map which would show how distributors are performing for each product.

Say there are five distributors which are added in chart series and measure as revenue. I dont have any category coordinates.. This should be a single product which will be based on the data radio button group .

I could see only select option and no filter option when defining a new connection between them.

When Product 1 is selected it will show the chart for product 1 with five distributors revenue.

As of now its showing all products and just selecting the first product.

Thanks,
Nithya
Title: Re: Data Radio Button and Column Chart
Post by: sujitgouda on 15 Aug 2014 11:10:54 AM
Design your chart inside a data deck below the Radio Button Group.
Filter Data deck card based on the Product.
Title: Re: Data Radio Button and Column Chart
Post by: MFGF on 15 Aug 2014 11:33:40 AM
Quote from: nithya1224 on 15 Aug 2014 10:41:08 AM
Hi All,

I have a data radio button group showing different products.

I want to have a map which would show how distributors are performing for each product.

Say there are five distributors which are added in chart series and measure as revenue. I dont have any category coordinates.. This should be a single product which will be based on the data radio button group .

I could see only select option and no filter option when defining a new connection between them.

When Product 1 is selected it will show the chart for product 1 with five distributors revenue.

As of now its showing all products and just selecting the first product.

Thanks,
Nithya

Hi,

Firstly, your Map would need to have the Product item added to its query.
You would next need to define a data deck, driven by the Product item, and the map would need to be within the data deck.
Next you would define a master/detail relationship between the map and the data deck, based on Product.
Finally you would set up a connection between your Product Data Radio Button Group and the Data Deck (based on Product), and select the first Product as the default for the variable as you define it. The Data Radio Button Group would need to SELECT the Data Deck, not filter it.

Cheers!

MF.