Click here for 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 a block storage database is the same as for creating an aggregate storage database, but you must create the block storage database within an existing block 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 MyBSOApp.Basic;

create or replace database DBS-NAME

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

Example:

create or replace database MyBSOApp.Basic;

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 MyBSOApp.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 MyBSOApp.New as Sample.Basic;

Creates a database called New within the MyBSOApp application that is a copy of the database Basic within the Sample application.

create currency database DBS-NAME

Create or replace a database for currency conversion. Linking a currency database to a main database enables you to convert currency values in a database from one currency into another currency.

Example:

create currency database Sample.Interntl;

Creates a currency database called Interntl within the Sample application.

create database DBS-NAME comment

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

Example:

create or replace database MyBSOApp.Basic comment 'Test cube.';

Creates a database called Basic within the MyBSOApp application, with a descriptive comment.