COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: gosoccer on 13 Oct 2015 10:37:34 AM

Title: Different Drill-Throughs from Different Intersections in Report Author 10.2.1
Post by: gosoccer on 13 Oct 2015 10:37:34 AM
Hi everyone,

I have a simple Crosstab report that I have build successfully without any issues. Now, I have to have different Drill-throughs
based on what is displayed as a part of the Slicing of the different values as Intersection. Please see the attache mock up.

Is there anyway possible to have Drill-Throughs based on a condition that if the cell values is SHOW JAGS, the Drill-though
will navigate to the SHOW JAGS Report or if it's SHOW BMW, the Drill-Though will navigate to SHOW BMI Report.

Thanks in advance for your time. :) :) Please Help if you can.
Title: Re: Different Drill-Throughs from Different Intersections in Report Author 10.2.1
Post by: andy_mason_84 on 13 Oct 2015 10:53:19 AM
Hi,

Just a though but could you not have both SHOW JAGS and SHOW BMW in the same report and then put a render variable on the JAG/BMW pages or on the JAG/BMW List/Crosstab items themselves based on what the passed value is?
Title: Re: Different Drill-Throughs from Different Intersections in Report Author 10.2.1
Post by: gosoccer on 14 Oct 2015 07:09:52 AM
Hi, thank you for the reply,

I take it you are mentioning the approach in which the drill through TARGET report includes several Conditioning Variable setup so based on what is passed from Source based on user's selection, the correct Report (Block/Crosstab/etc) will show.

right? :) :)
Title: Re: Different Drill-Throughs from Different Intersections in Report Author 10.2.1
Post by: andy_mason_84 on 15 Oct 2015 04:14:03 AM
Yeah pretty much although I would use Render Variables but that is the idea.
Title: Re: Different Drill-Throughs from Different Intersections in Report Author 10.2.1
Post by: gosoccer on 18 Oct 2015 05:18:53 PM
Thank you.