You can create a drill-through target analysis
and add target parameters in the analysis by setting a dimension as
the Go To parameter.
When
you create a drill-through definition for the analysis, this parameter
appears in the target parameter list.
To support drilling down
within the dimension and then drilling through, map the dimension
in the source metadata to the target dimension. The member or members
which are currently in your view are passed to the target analysis
as filter values. This applies to any query, report, or analysis used
in IBM® Cognos® Business Intelligence drill-through
actions. To support drilling through directly from a particular level,
map that level in the source metadata to the target dimension.
You
can set multiple parameters in an analysis target. However, you cannot
pass members within a selection set in Analysis Studio.
Procedure
- In Analysis Studio, create a cross-tab analysis using the
package that was set up for drill-through analysis.
- If you want, add as a row or column the data item that
you want to be the prompt.
- Move or add the dimension or level that you want to be
a target parameter to the Context area.
Note: You cannot pass members within a selection
set in Analysis Studio.
- View the list for the item in the Context area
and click Use as "Go To" Parameter.
- Save this analysis as your target report in IBM Cognos Connection.
You can now create the drill-through definition under a
source package.
Results
When you create the drill-through definition and use the cross-tab
analysis as a target, the
Go To parameter item
in the analysis appears as a drill-through parameter. You can map
to this parameter the same way that you drill through to Report Studio
or Query Studio reports.