Creating and Exporting Data to a Star Schema
You can create a star schema by specifying the prefix that identifies the tables for the schema and the dimension members of the cells to be exported. Before you export the data, make sure that the application data is consolidated.
Caution:
Do not use the Oracle Hyperion Financial Management database as the destination database for the data export.
Note: For Oracle database users: The extracted text data is stored in NVARCHAR(Unicode) format. Use the Oracle "translate" command in SELECT statements to convert the text from Unicode to ANSI format. For example, SELECT translate (LABEL using CHAR_CS) as LABEL FROM DEMO_ACCOUNT.
If you are extracting a large amount of data, make sure that you have adequate disk space for the extract.
Oracle recommends that you add 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 create a star schema and extract Financial Management data: