Generating Essbase Databases

  To generate an Essbase database:

1. Log on to Essbase.

2. In Performance Scorecard, select Administration, and then Star Schema Generation.

   The Star Schema Generation page is displayed.

3. Under Time Options, select the Date Range for the data to include in the Essbase database. Unless you require all dates, select Calculate for Dates to transfer data for a restricted date range.

4. Optional: If you selected Calculate for Dates, set the date range:

   1. Beside From Date, click the calendar button, .

      The Date Selector is displayed.

   2. Choose the first date in the range, then click OK.

      The selected start date is displayed.

   3. Beside To Date, click the calendar button, .

      The Date Selector is displayed.

   4. Choose the last date in the range, then click OK.

      The selected start date is displayed.

5. Under Time Options, under Generate Star Schema Rows, select the options for the information to include in the database:

   • When Result, Target, Scorecard Changes for a Measure or Scorecard—Create a row for any result, target or scorecard that has changed from the previous day for that measure or scorecard.

   • For Days From Frequency—Display data for the selected frequency, such as Daily, Weekly, and so on. This option only uses a date for a measure or scorecard if that date is in the set generated by the user selected frequency. To set a frequency, click Select, and choose the required frequency from the dialog box, then click OK.

   • Every Day displays the data for every available date.

6. Because the measure dimension may contain composite measure and perspective hierarchies in which perspectives are parents and measure children, specify a setting in Star Schema Structure:

   • Create with Measure Hierarchies—Generate a multidimensional database that produces the default Essbase database containing composite measure structures. Select this option to include composite measures, or measures used in the result formulas of other measures, in the database.

   • Create with Weights Included—Create a multidimensional database that generates an Essbase database that includes perspective-measure weightings. Use this option to present perspectives as level 1 entities and the measures they categorize as their children in the star schema.

   • Include Measures Linked to External Datasources—Use if specifying an external data source that contains data that is to be included in the database. See Using External Data Sources.

7. Click Generate Essbase database.

8. Click Create Database

   Generation may take hours, depending on the number of dimensions, members, and measure results. HPSImport.log documents the generation process. Review this file if theEssbase database was not generated.