Using Performance Scorecard Data With Interactive Reporting

You can useOracle's Hyperion® Interactive Reporting Studio to access Performance Scorecard data. The data displayed is obtained from the Star Schema tables that are generated in Performance Scorecard by administrators. By default, you can access Performance Scorecard data in Interactive Reporting using these pre-formatted reports:

To use Performance Scorecard with Interactive Reporting, perform these tasks:

  1. Create an ODBC connection, and add the connection to the DAS service.

  2. Create a database connection (anOCE file), that contains connection parameters. The integration retrieves results from the Interactive Reporting Server, using BQY files that are also created in Interactive Reporting. For detailed instructions on creating the OCE file, see the Interactive Reporting documentation.

  3. Publish the OCE file.

  4. Publish the BQY file which contains the queries and parameters for the report. See the Interactive Reporting documentation.

  5. Launch Performance Scorecard to generate the Star Schema database, and create the custom report links to view the reports.