Drilling Through from Cognos Series 7 to Cognos 8
You can set up drill-through access from Cognos Series 7
to Cognos 8. Specifically, you can drill through to a Cognos 8
report from a PowerPlay Web report or Cognos Visualizer report.
Drill through is supported for both PowerCubes and third-party cubes.
You must complete steps in both Cognos Series 7 and
Cognos 8 to enable drill through. Refer to the Cognos Series 7
documentation for the specific steps you must complete in the Cognos Series 7
components. Cross references to the appropriate Cognos Series 7
documents are included below.
Setting Up Drill-through Access from PowerPlay Web
Setting up drill-through access from PowerPlay Web
to Cognos 8 involves
 | for PowerCubes, specifying drill-through targets for Cognos 8
reports in the Transformer model For more information, see the Transformer documentation. |
| | for third-party cubes, specifying drill-through targets
for Cognos 8 reports in PowerPlay Connect. For more information, see the PowerPlay OLAP Server Connection
Guide. |
| | configuring drill-through access in PowerPlay Server Administration In addition to enabling drill-through access to Cognos 8,
you must specify the location of the Cognos 8 server and
the Cognos 8 folder that contains the target reports. For
more information, see the PowerPlay Enterprise
Server Guide. |
| | selecting the filters to add to the target report In PowerPlay Enterprise Server Administration, enable and use
Cognos 8 Assistance to identify the filter expressions
required in the target report. For more information, see the PowerPlay Enterprise Server Guide. |
| | creating and testing the target report  |
Setting Up Drill-through
Access from Cognos Visualizer
Setting up drill-through access from Cognos Visualizer
to Cognos 8 involves
| | specifying the Cognos 8 target and selecting the
filters to add to the target report You must configure drill through to Cognos 8 for individual
Cognos Visualizer reports. For more information, see the Cognos
Visualizer User Guide. |
| | creating and testing the target report |
Create and Test the Target Report
The target report must be based on a published package
that contains the metadata items that you want to filter on, or
contains items that are mapped to those metadata items.
When you create the target report, ensure that the names of the
parameters you add are identical to the parameter names listed in
the Drill Through Assistant page in Cognos Series 7.
However, the metadata item that you use in the target report for
that parameter name does not have to be the identical label. The
data values between the target parameter and the source value shown
in the drill assistant must match. You may also need to change the
type of operator in the target parameter from what is recommended
in the Drill Through Assistant. For example,
if the assistant recommends an = operator but you
want to pass a date range, you should change the parameter operator
in the target to in_range.
Steps
Start Report Studio and create a new report.
Add the data items and other objects you want.
From the Data menu, click Filters 
.
In the Detail Filters tab, click the
add button.
In the Expression Definition box,
create the parameterized filter you want by typing the filter expression.
Click OK.
In the Usage box, click Optional.
If you do not make the filter optional, a prompt page appears
when you drill through to the report.
Repeat steps 4 to 7 for other parameterized filters you
want to add.
Save the report.
The report name must match what you specified as a target in
the PowerCube, third-party cube, or Cognos Visualizer report.
Test the drill through in the PowerPlay report or Cognos
Visualizer report.
