Create and Test the Target for a Series 7 Report

You can create and test an IBM® Cognos® Series 7 report target to ensure the drill-through works properly.

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 IBM 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.

Before you begin

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.

Procedure

Start IBM Cognos 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, other cube, or IBM Cognos Series 7 Visualizer report.
Test the drill through in the IBM Cognos Series 7 PowerPlay® report or IBM Cognos Visualizer report.