Extracting Data to a Database

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.