COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: gosoccer on 17 Apr 2016 09:22:12 AM

Title: Calling Multiple Drill-Thurs from a Chart in Report Studio (10.2.1)
Post by: gosoccer on 17 Apr 2016 09:22:12 AM
Hi folks, :D

I have to call multiple Drill-Thrus to DIFFERENT Detailed Reports from a Source Bar Chart within a Report Studio Report.

So the Chart has different Bars (Categories) and I need to establish Drill-Thru from every Bar or any other way to trigger different Drill-Thru reports.

I know how to do it in reports but since it's a chart, I have no idea how to do this. Please help if you can.

Thanks in advance for your help. :) :)
Title: Re: Calling Multiple Drill-Thurs from a Chart in Report Studio (10.2.1)
Post by: mohanakkireddy16 on 18 Apr 2016 01:04:21 AM
Hi,

Even in chart its the same process. Move your cursor to the bar and then right click on that particular bar and go to related links. it will show what are the drill-through's present in the report.
Title: Re: Calling Multiple Drill-Thurs from a Chart in Report Studio (10.2.1)
Post by: gosoccer on 18 Apr 2016 07:37:10 AM
Hey, thanks for the reply!  :) :)

In Reports, I developed the Crosstab that allowed Drill-thru to different Reports without using the Right Click - Menu that you
were mentioning. So, when the user selected any intersection of the Crosstab, they were navigated to a DIFFERENT report by
just selecting the Count value shown.

I'm trying to implement the same functionality by using a Chart - Detailed Report.

Thanks for your time
Title: Re: Calling Multiple Drill-Thurs from a Chart in Report Studio (10.2.1)
Post by: ARod on 11 Nov 2016 02:44:21 AM
Facing similar issue.

Seems in Cognos 8 it used to work using the steps mentioned here -
http://cognosandme.blogspot.in/2010/06/drill-through-to-different-reports-on.html

Anyone able to achieve this for Cognos 10 Charts ?

Update - The above link works for Cognos 10 too ( In dimensional model use Attributes to achieve the same - This was the issue with my chart ).
Title: Re: Calling Multiple Drill-Thurs from a Chart in Report Studio (10.2.1)
Post by: gosoccer on 31 Jan 2017 11:35:13 AM
Thank you Arod. My apologies for not getting back to you sooner. I'll review the document and see if I can use this approach.  8)