COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: kumarhanu on 02 Feb 2013 06:20:27 AM

Title: How to create a link between a Chart and a List
Post by: kumarhanu on 02 Feb 2013 06:20:27 AM
Hi All,

I am new to Cognos Report Studio. I am looking for help from experts.

Created a List using with multi dimensions and drill up/drill down behavior. Created a Chart. Values in the chart are NOT changing according to the change in values while doing drill-down/drill-up in the List.

Is it possible to create link between a Chart and List?

Thanks.
Title: Re: How to create a link between a Chart and a List
Post by: CognosPaul on 03 Feb 2013 03:52:15 AM
Does the same data item appear both in the list and chart? Is it the same query?

If the answers are Yes and No, open Drill Behavior->Data Item Linking and double click on the items from both queries.

If the answers are both no, create a new data item: total(currentMeaure within set [Drilled Item]) and drag that to the slicer.
Title: Re: How to create a link between a Chart and a List
Post by: kumarhanu on 04 Feb 2013 06:14:27 AM
Thanks PaulM for the quick response. We tried with the solution 1 that you have given. List is properly get updated but Chart is not getting updated even after Data -> Drill behavior -> Data item linking -> link both the queries.

Is they any thing I missed out. Thanks in advance.
Title: Re: How to create a link between a Chart and a List
Post by: CognosPaul on 04 Feb 2013 06:23:17 AM
Did you try the second suggestion?
Title: Re: How to create a link between a Chart and a List
Post by: HalfBloodPrince on 04 Feb 2013 10:34:56 PM
Use same query for both List and Chart