8 Extracting Data to a Database

Use the procedures in this chapter to extract data to a database.

Note:

To extract data as flat files, see the Extracting Data section in the Oracle Hyperion Financial Management User's Guide .

You can extract data and use an Oracle Essbase database to analyze the data and produce reports. You use a star schema to send data to an Essbase database. You can also use a star schema with third-party products.

Note:

You create the database after you export data to the star schema. To create a database, see the database documentation for your release.

Before you extract data to a database, you must set up a data source name (DSN) for the database to store star schemas. To store star schemas in multiple databases, you can create a DSN for each database. For instructions, see the Oracle Enterprise Performance Management System Installation and Configuration Guide .

To extract data to a database, you must be assigned the Administrator or Extended Analytics security role.

If you are not assigned the Extended Analytics security role, these restrictions apply for extracting data:

• You can extract only base level data for ICP and all Custom dimensions.

• You can select only one Scenario and one Year dimension.

• You can select only the Periods that are in the Scenario's default frequency.