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 case-sensitive.

Permission required: create_application. To copy an application, designer permission on the source application is additionally required.

Syntax

Examples

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

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

Descriptions

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

Key Phrase Explanation
create application Create a new application. Application names are case sensitive.
create or replace application Create an application, or replace an existing application of the same name. Application names are 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 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.

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com