Updating a Star Schema

You can export data to a previously defined star schema. When you update a star schema, you can specify different dimension members.

Note:

When you update a star schema, the system clears data from the Fact table only.

Oracle recommends that you add Financial Management to the exceptions for your Web pop-up blocker. When you perform some Financial Management tasks on the Web such as loading data, a status window pops up showing the task status. If you have a pop-up blocker enabled on your computer, the status window is not displayed.

  To update a star schema:

  1. Open the application.

  2. Select Administration, then Extended Analytics.

  3. Do one of these tasks:

    • From Template, select the saved POV template to use.

    • Select the POV dimension members to export.

  4. From Destination Database (DSN), select the database that contains the star schema.

  5. For Relational Table Prefix, type the prefix that identifies the tables for the star schema.

    Note:

    The prefix can contain up to 10 alpha-numeric characters and must start with a letter. The default prefix is the application name.

  6. From Extract Format, select the type of extract to perform on the data.

    • Standard

    • Metadata Only - extracts metadata only

    • Selected Metadata Only - extracts only the metadata for the selected dimension members.

    • Essbase

    • Data Warehouse

    Note:

    The Flat File option is not available for this action.

  7. Optional: Uncheck the Exclude Dynamic Accounts option to include dynamic accounts in the star schema.

  8. Select Update Star Schema.