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 updates the Fact table.

Oracle recommends that you add Oracle Hyperion Financial Management to the exceptions for your Web pop-up blocker. When you perform some tasks 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. Select Consolidation, then Extract, and then Data.
2. Do one of these tasks:

   • If you saved POV dimensions in a template, from Template, select the template.

   • If you are not using a template, select the POV dimension members to export.

3. From Extract Destination Type, select Database.

   Note:

   This option is only available if you are assigned the Administrator or Extended Analytics security role.

4. From Extract Format, select an option:

   • Standard

   • Metadata Only - extracts metadata only

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

   • Essbase

   • Data Warehouse

5. From Options, select one or more options:

   • Extract Dynamic Accounts

   • Calculated Data

   • Derived Data

6. From Line Item Details, select an option:

   • Total Summary for Cell

   • None

7. From Schema Actions, select Update Star Schema.
8. From Destination Database (DSN), select the database to which you are exporting the star schema.

   Note:

   Do not use the same Financial Management database from which you are exporting data as the destination database.

9. For Relational Table Prefix, enter a prefix that to identify the tables for the star schema, or use the default application name prefix.

   Note:

   The prefix can contain up to 10 alphanumeric characters and must start with a letter. It cannot contain an underscore. The default prefix is the application name.

10. Click Extract.