If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Drill through problem

Started by rishabh, 01 Nov 2006 04:09:53 AM

Previous topic - Next topic

rishabh

Hi all,

I have a requirement to create a drill through report where the main report is an index to the drill through reports. The index value is passed to the drill through report, but it can not be the filtering criteria.
For example, if A list of reports are displayed as a main report which is built using reporting table specially built for this purpose. Clicking on the data value (which becomes the name or the index) should open the actual report. There are no common criteria among the drill through reports including the data items or the criteria.

For eg.
Main Report has a list of reports as data field say <Report Name> with values as "Report1", "Report2", "Report3" etc.
The drill through reports should be on <Report Name> which would link to Report1, Report2 Report3 etc based on which value is clicked in the main report.

Please let me know if its possible to be done in Cognos 8.1. I am using Report Studio.

Thanks in advance.
Cheers!

Blue

I am confused by the requirement here.  From what I read it sounds like you are using a report as a menu to call other reports.  If this is so why?  Cognos Connection would be more suitable for creating such a menu of reports and the reports to be run won't be drill through reports requiring a filter.
Robert Edis
Principal
Robert Edis Consulting
Rotorua, New Zealand

anirudha

I have done this but in my case I had a small list of Report names. I just hot coded the names the row cells of table and assigned drill throughs respectively.
If you want to populate 'Report Names' from database table then this might not be the best approach.

-A


Quote from: Blue on 01 Nov 2006 12:52:53 PM
I am confused by the requirement here.  From what I read it sounds like you are using a report as a menu to call other reports.  If this is so why?  Cognos Connection would be more suitable for creating such a menu of reports and the reports to be run won't be drill through reports requiring a filter.


larsonr

Refer to the best practices guide at support.cognos.com under the reports section.    There are two documents on having a menu driven report that can call other reports. 

The other option is to create an HTML item that calls all the URL paths to those reports with a javascript menu structure.