Create Calculation

Create, replace, or copy a stored calculation.

Permissions required: Database Manager to create database-level calculations. Application Manager to create application-level calculations.

Syntax

Use create calculation to create a calculation in the following ways:

Keyword	Description
create calculation	Create a calculation script, the body of which is specified by CALC-STRING.
create or replace calculation	Create a calculation script, the body of which is specified by CALC-STRING. If a calculation script of that name alreay exists, it is replaced.
create calculation as	Create a calculation as a copy of another stored calculation.

Notes

When creating database-level calculations, this statement requires the database to be started.
A stored calculation can be associated with an application/database, or with an application only. To create an application-level calculation, use two tokens for CALC-NAME. To create a database-level calculation, use three tokens. See CALC-NAME for more details.
Calculations created using MaxL must be valid. For information about calculation syntax, see the Oracle Essbase Database Administrator's Guide.

Example

create or replace calculation sample.basic.Accts
'SET UPDATECALC ON;
CALC DIM(Accounts);'
;

Creates a calculation named Accts that is associated with sample.basic.

create calculation sample.basic.Accts2 as app.db.Accts

Creates a calculation named Accts2 on sample.basic that is a copy of another database's calculation named Accts.