Drill through in Active Reports is same as traditional report; however, this functionality is only available while user is connected to the Cognos environment, as generated .mht is not bringing the drill through report with it.
This document is intended to provide a few initial solutions to do drill through in case when user is requested to look at report on iPad without connection to the Cognos environment. Please note that all sample attached is applied for version 10.1 (not version 10.1.1)
Drill through with connection to Cognos environment
Please download report specification for main and drill through report and .mht file for review in detailThis is to use traditional way to develop drill through report. You can define the drill through as below by passing Region.
When click revenue, you get the detail report.
However, you get error message when you are not connected with Cognos environment.
Drill through from a list with one variable
Please download report specification for main and drill through report and mht file for review in detailIn order to make drill through work, we need to define a data deck to act for two proposes:
- Contain drill through report to decide whether it should show or not, therefore there is default card
- Contain drill through report to decide what region to use to show
The communication from list to drill through list is done by deck via variable varRegion. Drill through report is setup master detail relationship via region.
Drill through from a list with two variables
Please download report specification for main and drill through report and mht file for review in detailNormally, there are many parameters in drill through definition. Two parameters, region and Order method, are used in this sample. Two variables are defined accordingly as varRegion and varOrderMethodType
See result below
Drill through from a crosstab with two variables
Please download report specification for main and drill through report and mht file for review in detailNow, we’re trying to apply the same concept for Crosstab, actually, there are almost no changes at all, except turn list top crosstab. Result below
Drill through from a chart with two variables
Please download report specification for main and drill through report and mht file for review in detailFurthermore, we can turn Crosstab to chart. It works as well.
Fantastic guidance! helped me at right time! Cognos Online Training
ReplyDeleteThe regular drill thru 'Drill through with connection to Cognos environment' does not work. It worked when the report was not an active report. When it was changed to an active report, it gives an error 'page not found'. Can only 1 drill thru report be defined for a column?
ReplyDelete