Create Application

The MaxL create application statement for block storage (BSO) helps you create or re-create an Essbase application. Every Essbase database (cube) must be created within an application. If the cube is intended to be block storage, then the application must be block storage.

Click here for aggregate storage version

You can create the application either from scratch or as a copy of another application on the same server. The permission required to create an application is power user or system administrator.

See APP-NAME for information on the maximum length of and special characters that are allowed in an application name. Application names are not case-sensitive.

Keywords

Use the MaxL create application statement to create a block storage (BSO) application in the following ways.

create application APP-NAME

Create a new application intended for a block storage (BSO) cube.

Example:

create application MyBSOApp;

Creates an application called MyBSOApp.

create or replace application …

Create an application intended for a BSO cube, replacing an existing application of the same name, if one exists.

Example:

create or replace application MyBSOApp;

Creates an application called MyBSOApp. If an application named MyBSOApp already exists, it is overwritten.

create application APP-NAME type nonunicode_mode

Create a non Unicode-mode application intended for a block storage database. Non-Unicode mode is the default application type that is created, even if these keywords are omitted.

Example:

create application MyBSOApp type nonunicode_mode;
create application APP-NAME type unicode_mode

Create a Unicode mode application intended for a block storage database.

Example:

create application MyBSOApp type unicode_mode;
create application APP-NAME as APP-NAME

Create an application as a copy of another application. To copy an application, Application Manager permission on the source application is required, in addition to the power user role required to create an application.

Example:

create application MyBSOApp as Sample;

Creates a block storage application called MyBSOApp, which is a copy of the gallery sample application named Sample.

create application APP-NAME comment COMMENT-STRING

Create a block storage application including a short description (optional). The description can contain up to 80 characters.

Example:

create application MyBSOApp comment 'This is a test application.';