Creating a Data Source

You must set up a data source name (DSN) to store star schemas. See "Configuring a Data Source Name (DSN)" in the Oracle Hyperion Financial Management Administrator's Guide for details.

To create a data source:

1. Access Oracle Hyperion Enterprise Performance Management Workspace. See Accessing EPM Workspace.
2. Select Navigate, then Administer, and then Consolidation Administration.
3. In Consolidation Administration, select Configure DSN.
4. In Configure DSN, click Actions, and then select Create Data Source.
5. Enter settings to create a data source. See "Configuring a Data Source Name (DSN)" in Oracle Hyperion Financial Management Administrator's Guide for details.
6. Click Test Connection to ensure that the data source properties that you set are valid.
7. Click Save.