Drill Through in IBM Cognos 8 Powerplay Cubes

In IBM Cognos 8, drill-through targets are created in IBM Cognos Connection using package-based
(or model-based) drill-through definitions.
There are several benefits to authoring and storing the drill-through paths in IBM Cognos Connection
instead of in the Transformer model:
●The Transformer modeler does not need to specify any target reports or settings in the model
for the purposes of drill through.
● When changes to drill-through paths are required, the PowerCube does not have to be rebuilt
or updated.As a result, end users are less affected by cube rebuilds or updates.
● Drill-through paths can be defined by report or analysis users.
Because report or analysis users can define drill-through paths according to their needs, they
are less dependant on the Transformer modeler.

Note: In Transformer version 7.x, when the PowerCube was to be used in an IBM Cognos 8 drill throughdefinition, the Transformer modeler was required to enable the Allow drill through for this PowerCube check box on the Drill Through tab on the PowerCube property sheet. This ensured that the source value was passed as the business key during PowerCube to relational scenarios. In Transformer version 8.x, this is not required; the source value will always be passed as the business key to relational target reports.