Click here for non-aggregate storage version

See DBS-NAME for information on the maximum length of and special characters that are allowed in a database name. Database names are not case-sensitive.

The syntax for creating an aggregate storage database is the same as for creating a block storage (BSO) database, but you must create the aggregate storage database within an existing aggregate storage application.

The minimum permission required to create a database is Application Manager. To copy a database, at least Database Manager permission on the source database is also required.

Syntax

• DBS-NAME

• COMMENT-STRING

Keywords

Use the MaxL create database statement to create an Essbase cube in the following ways:

create database DBS-NAME

Create a new database.

Example:

create database MyASOApp.Basic;

create or replace database DBS-NAME

Create a database, or replace an existing database of the same name.

Example:

create or replace database MyASOApp.Basic;

Creates a database called Basic within the MyASOApp application. If a database named Basic within the MyASOApp application already exists, it is overwritten.

create database DBS-NAME using non_unique_members

Create a database that supports the use of duplicate member names. Once you have created a database with a duplicate member outline, you cannot convert it back to a unique member outline.

Example:

create database MyASOApp.Basic using non_unique_members;

For more information about duplicate member names, see Creating and Working With Duplicate Member Outlines.

create database DBS-NAME as …

Create a database as a copy of another database.

Example:

create database MyASOApp.New as ASOSamp.Basic;

Creates a database called New within the MyASOApp application that is a copy of the database Basic within the ASOSamp application.

create database DBS-NAME … comment

Create a database description (optional). The description can contain up to 80 characters.

Example:

create database MyASOApp.Basic comment 'New ASO cube';

Notes

• You cannot create an aggregate storage database as a copy of another aggregate storage database. Only one aggregate storage database is allowed per application.

• You cannot copy a block storage database to an aggregate storage database. For an example of how to create an aggregate storage application and database based on a block storage application and database, see Create an Aggregate Storage Sample Using MaxL.