With Cube Designer and with Essbase web interface, you can easily create an application and database using an Excel-based application workbook. You can use a sample application workbook and modify it for your use.

If you already created an application and database, and you want to base a new application and database on it with some modifications, export the application and database to an application workbook. After you make the changes to the application workbook, you can then import the new application and database.

When you create an application, its artifacts are created on the Essbase Server machine in the <Oracle_Home>/applications/essbase/app/<appname> directory, where the appname subdirectory has the same name as the application.

When you create a database, subdirectories for the database are created within the application directory. The subdirectories that are created depend on the database type:

• Block storage—<dbname>/cube subdirectories. The dbname subdirectory has the same name as the database.

• Aggregate storage—dbname subdirectory. The dbname subdirectory has the same name as the database.

You can use MaxL statements to create applications and databases.

• create application

• create database

Before naming applications and databases, see Naming Conventions for Applications and Databases.

Other References

About Application Workbooks

Create a Cube from an Application Workbook