Working with Essbase Database

Oracle Hyperion Planning applications require an Oracle Essbase database to store outlines, dimensions and their members, data forms, and filters. Because this database is not automatically created during the Planning application creation process, you must create it.

Data about custom dimensions and members and data forms are not automatically written into the Essbase database. If you create custom dimensions after creating the database, you must refresh the database to write the information into it.

To work with the Essbase database:

1. Open the Planning application. See Accessing Planning Applications.
2. Select Administration, then Application, and then Create Database.

   Existing dimension, dimension member, and access permission data is automatically written into the database.

   Note:

   In Oracle Essbase Administration Services, the database that you created is listed under your Planning application node within the Essbase Server node.

3. Select database options. Consult online help for assistance.
4. Click Create.