COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: ddma on 07 Jan 2021 11:07:44 AM

Title: cognos report chart connection
Post by: ddma on 07 Jan 2021 11:07:44 AM
Hi All.

Is it possible to connect 2 charts in cognos reporting, so when if I press i.e. on segment of pie chart another chart changes based on selected data only? I mean the same functionality we have in Cognos Dashboard.

Thanks
Title: Re: cognos report chart connection
Post by: MFGF on 07 Jan 2021 12:08:56 PM
Quote from: ddma on 07 Jan 2021 11:07:44 AM
Hi All.

Is it possible to connect 2 charts in cognos reporting, so when if I press i.e. on segment of pie chart another chart changes based on selected data only? I mean the same functionality we have in Cognos Dashboard.

Thanks

Hi,

There are two possibilities I can think of for this, but neither is particularly easy.

1. Create an Active Report. You will need to learn how the Active Report containers and controls work with each other (using active report variables), and also be mindful that the data for the report gets loaded into the rendered report output, so it may be large and possibly stale if the report output hasn't been generated recently.
2. Look at report drill-through to the same report. This can get confusing, though, and you will want to prevent the end users from drilling too many levels deep.

Is there a reason a dashboard doesn't answer the requirement you have?

Cheers!

MF.