Generating an Interactive Reporting Report

After you create and import the OCE and BQY files, you can generate the selected report.

  To generate a report through Interactive Reporting:

  1. From the Windows menu, select Start, then Settings, then Control Panel, and thenServices to display the Services window.

    Ensure the Workspace Agent Service and Workspace Web Application services are running:

  2. Launch EPM Workspace, using

    http://server:port/workspace

  3. Log on to Performance Scorecard as an Administrator.

  4. Select Administration, and then Star Schema Generation.

    The Star Schema Generation page is displayed.

  5. Select the settings you require to generate the Performance Scorecard Star Schema tables:

    • Under Time Options, select the dates for which to view results. If you do not need data for all dates, select Calculate for Dates from Date, and select a date range from the calendar.

    • Under Generate Star Schema Rows, select the dates that you require data to be generated for the report.

    • Under Star Schema Structure, select the appropriate option. If you use measure weights, select Create with Weights Included.

    • Disable \ Do NOT select these options:

    1. Conform to Essbase Naming Restriction

    2. Generate Essbase Database

  6. Click Create Database.

  7. Optional: Create a link to the report. See Adding Links to Custom and Interactive Reporting Reports.