COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: dsmuker on 02 Oct 2019 12:45:27 AM

Title: Drill through in Cross tab
Post by: dsmuker on 02 Oct 2019 12:45:27 AM
Hi

I have a cross tab with clustered column chart along with measure in the intersection cells. The master detail info is well defined. Unfortunately when i establish the drill through definition it is not able to filter the target report data based on the axis field in the bar chart.
the data item values are well defined to be passed as parameter values in the target report.

Am i missing anything?
Title: Re: Drill through in Cross tab
Post by: MFGF on 02 Oct 2019 07:07:25 AM
Quote from: dsmuker on 02 Oct 2019 12:45:27 AM
Hi

I have a cross tab with clustered column chart along with measure in the intersection cells. The master detail info is well defined. Unfortunately when i establish the drill through definition it is not able to filter the target report data based on the axis field in the bar chart.
the data item values are well defined to be passed as parameter values in the target report.

Am i missing anything?

Where is your drill-through definition defined? On the crosstab or the chart? What sort of chart is it - an 11.1 viz, an 11.0 viz, a legacy viz or a Cognos 10 chart?

MF.
Title: Re: Drill through in Cross tab
Post by: dsmuker on 02 Oct 2019 09:12:06 PM
It is a pie chart.
Title: Re: Drill through in Cross tab
Post by: MFGF on 03 Oct 2019 07:04:17 AM
Quote from: dsmuker on 02 Oct 2019 09:12:06 PM
It is a pie chart.

Hi,

Pie charts are available in all four variants I'm asking about - 11.1 viz, 11.0 viz, legacy viz and Cognos 10 chart. Which one of the four is it?

MF.
Title: Re: Drill through in Cross tab
Post by: dsmuker on 03 Oct 2019 06:00:53 PM
It is cog 11.0.7
Title: Re: Drill through in Cross tab
Post by: MFGF on 04 Oct 2019 06:56:59 AM
Quote from: dsmuker on 03 Oct 2019 06:00:53 PM
It is cog 11.0.7

Hi,

In that case it can't be an 11.1 visualization, but that still leaves three other variants it could be. When you add a visualization to a report, you will see a filter icon in the top right corner that allows you to choose which variant of chart/visualization to select from:

(https://image.ibb.co/bDWqPy/Viz-Filters.png)

Which of these did you use in this report?

MF.