Create Calculation

Create, replace, or copy a stored calculation. Permissions required: Database designer to create database-level calculations. Application designer to create application-level calculations.

Syntax

Notes

Examples

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.

Descriptions

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

Key Phrase Explanation
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.

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