Generating an Interactive Reporting Report

After the OCE and BQY files are imported to Interactive Reporting, you can generate reports.

  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.

  2. Ensure that the Hyperion Workspace Agent and Hyperion Workspace Web Application services are running.

  3. Launch Oracle Enterprise Performance Management Workspace, Fusion Edition, using this URL:

    http://server:port/workspace

  4. Log on to Performance Scorecard as an Administrator.

  5. Select Administration, and then Star Schema Generation.

    The Star Schema Generation page is displayed.

  6. Select the desired content:

    • 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.

      Note:

      The dates specified in the Smart Cut URL must exist in the set of data that you are saving to the Performance Scorecard Star Schema tables.

    • 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.

  7. Clear Generate Oracle Essbase Database and Conform to Essbase Naming Restrictions.

  8. Click Create Database.

  9. Optional: Create a link to the report.