COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: brianknott on 22 Jan 2014 06:05:33 PM

Title: Pie Chart drill throughs
Post by: brianknott on 22 Jan 2014 06:05:33 PM
Hi All.
I have a page that contains a 2 pir charts woth drill through on each chart.  One chart is actuals and one is budget.
When I set up the drill through to a detailed report I have 2 parameters, period and scenario.  The period is driven from a prompt so no issues there.  The scenario is driven from a data item in the query.
The issue is that the scenario is not being passed to the detailed report.  The detailed report is prompting for a scenario when you drill.
I can right click and use the drill assistant and i can see the period parameter, but no scenario parameter.  Is there a trick to passing a parameter to a report that is actually a data item.

Brian
Title: Re: Pie Chart drill throughs
Post by: MFGF on 23 Jan 2014 02:44:42 AM
Hi,

How have you defined your drillthrough definition? In particular, how have you defined "Method" for each passed value? I would imagine you will use "Pass parameter value" for the period and "Pass data item value" for the scenario? Are the source and target reports based on a dimensional or relational package (or a mix)?

Cheers!

MF.