You can use Interactive Reporting Studio to directly access Performance Scorecard data through Star Schema database tables. The reports are presented in a combination of tables that provide detailed and summary information, and graphical charting of those results.
By default, these pre-formatted Performance Scorecard reports are available through Interactive Reporting:
The Star Schema tables are used by an Administrator to generate Essbase databases and Interactive Reporting reports. The data that is displayed in the reports is obtained from the Star Schema tables that are generated in Performance Scorecard. For additional information, see Star Schema Tables.
Create an ODBC connection, and add the connection to the DAS service.
Create a database connection (an.oce 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.
Publish the BQY file, which contains the queries and display parameters for the information to be generated for the report. You can use the default BQY files, or create your own. For more information, see the Interactive Reporting documentation.
After the files have been set up in Interactive Reporting, launch Performance Scorecard to generate the Star Schema database, and create the custom report links to view the reports.