Check the Target and Source Report

You can check the target and source report to ensure that drill-through will work properly.

Procedure

  1. Open the target report, Actual vs. Planned Revenue, in Report Studio.
    • Go to IBM Cognos Connection.
    • In Public Folders, open the package Sales and Marketing (cube), and then open the folder Report Studio Report Samples.
    • Select the report Actual vs. Planned Revenue, and click the Open with Report Studio icon.
  2. In the Actual vs Planned Revenue report in Report Studio, confirm that you have parameters for order method and time.
    • Open the query explorer tab and select Query 1.
    • In the Detail Filters box, confirm that a filter parameter exists for each of Order Method and Year, and note the parameter names.
  3. From the Data Items box, note the name of the measure that you plan to use for the scope (Revenue)
  4. Close the Actual vs Planned Revenue report.
  5. Open the source report, Custom Rank Sample, in Analysis Studio.
    • Go to IBM Cognos Connection.
    • In the Public Folders, open the package Sales and Marketing (cube), and then open the folder Analysis Studio Report Samples.
    • Select the report Custom Rank Sample, and click the Open with Analysis Studio icon.
  6. In the Custom Rank Sample report in Analysis Studio, check the name of the measure that you want to use to restrict scope (Revenue).
  7. Check the rows and columns in the report and confirm that the data structure will match the parameters in the Actual vs Planned Revenue report.

    Tip: Pause the mouse over a label in the cross-tab to see the path.

  8. Leave the Custom Rank Sample report open for testing.
Parent topic: Example - Drill Through Between OLAP Reports in the Same Package