Create Application (Aggregate Storage)

Click here for non-aggregate storage version

Create or re-create an application, either from scratch or as a copy of another application on the same system. APP-NAME must consist of 8 or fewer characters. Avoid spaces and special characters when naming applications and databases. Application names are not case-sensitive.

Permissions required: Essbase create_application role and Oracle's Hyperion® Shared Services Project Manager role.

To copy an application, Application Manager permission on the source application is also required.

Syntax

Syntax diagram for create application (aggregate storage).APP-NAMECOMMENT-STRING

You can create an application in the following ways using the aggregate storage version of create application.

KeywordDescription

create application

Create a new application. Application names are not case-sensitive.

create or replace application

Create an application, or replace an existing application of the same name. Application names are not case-sensitive.

...type nonunicode_mode

Create a Non Unicode-mode application. This is also the default if these keywords are omitted.

...type unicode_mode

Create a Unicode-mode application.

...using aggregate_storage

Create an application using an aggregate storage model. Only one database per application is allowed. Selecting to use aggregate storage model for an application is non-reversible.

Use the aggregate storage model if the following is true for your database:

  • The database is sparse and has many dimensions, or a large hierarchical depth of members in the dimensions.

  • The database is used primarily for read-only purposes; there are few or no data updates.

  • There are no formulas on the outline except in the dimension tagged as Accounts.

  • Calculation of the database is frequent and highly aggregational, with no dependency on calculation scripts.

create application as

Create an application as a copy of another application. Application names are not case-sensitive.

You cannot copy block storage applications to aggregate storage applications or vice versa. The copy will always use the same storage as the original. However, you can convert an outline from a block storage database to an aggregate storage database, using create outline.

comment

Create an application description (optional). The description can contain up to 80 characters.

Example

create application Sample2 using aggregate_storage comment 'aggregate storage application.';

Creates a new aggregate storage application called Sample2, with an associated comment.