Set Up Parameters for a Drill-through Target in Analysis Studio

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

  1. In Analysis Studio, create a cross-tab analysis using the package that was set up for drill-through analysis.
  2. If you want, add as a row or column the data item that you want to be the prompt.
  3. 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.
  4. View the list for the item in the Context area and click Use as "Go To" Parameter.
  5. 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.
Parent topic: Setting Up Parameters for a Drill-Through Report