Set Up Drill-through Access from PowerPlay Web

Setting up drill-through access from PowerPlay® Web to IBM® Cognos® Business Intelligence involves setting up target reports.

Procedure

  1. For PowerCubes, specify drill-through targets for IBM Cognos BI reports in the Transformer model. For other cubes, specify drill-through targets for IBM Cognos BI reports in PowerPlay Connect.

    For more information, see the Transformer documentation or the PowerPlay OLAP Server Connection Guide

  2. For other cubes, specify drill-through targets for IBM Cognos BI reports in PowerPlay Connect.
  3. Configure drill-through access in PowerPlay Server Administration.

    In addition to enabling drill-through access to IBM Cognos BI, you must specify the location of the IBM Cognos BI server and the IBM Cognos BI folder that contains the target reports. For more information, see the PowerPlay Enterprise Server Guide.

  4. Select the filters to add to the target report.

    In PowerPlay Enterprise Server Administration, enable and use IBM Cognos BI Assistance to identify the filter expressions required in the target report. For more information, see the PowerPlay Enterprise Server Guide.

  5. Create and test the target report.

    For more information, see Create and Test the Target for a Series 7 Report.