Creating Planning Data Source

Each Oracle Hyperion Planning application requires a unique data source, which comprises connection information for a Planning application database and an Oracle Essbase Server. Because a Planning application database can store information from only one Planning application, each data source requires a unique database. Many data sources can use an Essbase Server.

To create a data source:

1. Access Oracle Hyperion Enterprise Performance Management Workspace as a Functional Administrator. See Accessing EPM Workspace.
2. Select Navigate, then Administer, and then Planning & Budgeting Service.
3. In Planning Administration, click Manage Data Source.
4. From Actions in Manage Data Source, select Create.
5. In Data Source Name, enter a name.
6. From Database, select the database type for the Planning application database.
7. Enter connection information for application database and Essbase server. Ensure that you enter information for an Essbase Server administrator (or Functional Administrator) in Essbase Server settings. Consult online help for assistance.
8. Click Validate to validate the Application Database Connection and the Essbase Server Connection.
9. Click Save to create the data source.