Print Page - Cognos Drill Down Query

Title: Cognos Drill Down Query
Post by: Raghuvir on 16 Nov 2018 08:26:15 AM

Hi All,
Cognos Version: Cognos 11.0.7
Package : Dimensional

We are facing a strange issue with the drill down functionality of Crosstab.
On our crosstab we have about 12 measures ( as crosstab columns ) and a hierarchy ( Group -> Division -> Region -> Facility ) as crosstab rows .
It is observed that because of no of measures in the crosstab, drill functionality for crosstab rows at the facility level gets disabled for records
If we reduce the no of measures ( crosstab columns ) to 8 the drill functionality works perfectly fine. ( Looks like memory Issue )

Any thoughts on how to get the drill functionality working for all the measures?

Thanks,
Raghuvir

Title: Re: Cognos Drill Down Query
Post by: Reinhard on 19 Nov 2018 02:36:47 AM

Hi,

I just tried 10 measures with years in the rows in C11.0.12 and drill down works. Upgrade your Cognos.

Regards,
Reinhard

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: Raghuvir on 16 Nov 2018 08:26:15 AM