Create, replace, or copy a stored calculation. Permissions required: Database designer to create database-level calculations. Application designer to create application-level calculations.
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.
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 |