Generating Star Schema Tables

Generate Star Schema tables for a predefined set of Performance Scorecard data. See Generating Essbase Databases.To regenerate the Scorecard Star Schema tables on a regular basis, schedule the star schema generation to automatically initiate the generation process. See Scheduling Automatic Database Generation.

Before generating tables, all spaces on the database schema must be set to be auto-expandable to ensure there is sufficient space to accommodate data being transferred.

Although you need not to followEssbase naming conventions now, you will if you later generate an Essbase database. If necessary, members are automatically renamed by the application to conform to the naming conventions. See the Oracle Hyperion Performance Scorecard User Guide for restricted characters.

  To generate Star Schema tables:

  1. Select Administration, then Star Schema Generation.

    The Star Schema Generation page is displayed.

  2. Under Time Options, for Date Range, select the option for the period of time for which to generate data in the Star Schema tables:

    • Calculate for All Dates.

    • Calculate for Dates, with an associated date range.

      Note:

      Unless you require all dates, select Calculate for Dates to transfer data for a restricted date range.

  3. Optional: If you selected Calculate for Dates, click the calendar button, The image calendar.gif displays the calendar button. in To Date and From Date to select the first and last day in the range.

  4. Under Time Options, for Generate Star Schema Rows, select the type of information to include in rows:

    • When Result, Target, Score Changes for a Measure or Scorecard—Create a row for any result, target or scorecard that has changed.

    • For Days From Frequency—Display the data for the selected frequency. This option only generates data for a measure or scorecard if that data is available on the frequency date. To set a frequency, click Select.

    • Every Day—Display data for every day between the start and end dates.

  5. Because the measure dimension in an Essbase database may contain composite measure hierarchies and perspective measure hierarchies, select an option from Star Schema Structure:

    • Create with Measure Hierarchies—Generate a star schema that produces the default database containing composite measure structures. This includes composite measures, or measures used in the result formulas of other measures, in the Star Schema.

    • Create with Weights Included—Create a Star Schema that generates a database that includes perspective-measure weightings. This presents perspectives as level 1 entities and the measures they categorize as their children.

      Note:

      This allows you to create data base query. See Creating View Queries.

    • Optional: Select Include Measures Linked to External Datasources only if you will include data from an external source in the Star Schema. See Using External Data Sources.

  6. Optional: Select Conform to Essbase Naming Restrictions to format all names using Essbase naming conventions. This may involve removing restricted characters from names, for example.

  7. Click Create Database.

    Performance Scorecard generates the HPS_STAR relational database tables. Access your database to view the results in the Star Schema tables.

    You can use the results to generate reports through Interactive Reporting. See Extended Customized Reporting.