Execute Calculation

Execute a stored calculation, the stored default calculation (determined by alter database), or an anonymous (non-stored) calculation string.

Minimum permissions required:

Syntax

Notes

A stored calculation can be associated with an application/database, or with an application only. To execute a calculation stored at the application level, you must specify which database to calculate using the syntax 'on database STRING.'

Examples

execute calculation Sample.Basic.calcname;

Calculates the Sample.Basic database using a stored calculation file assocatied with the database.

execute calculation Sample.calcname on database Basic;

Calculates the Sample.Basic database using a stored calculation file assocatied with the application Sample.
execute calculation 
  'SET MSG ERROR;
   CALC ALL;'
on Sample.basic;
Calculates Sample.Basic using an anonymous (unstored) calculation string.

Descriptions

You can run calculations in the following ways using execute calculation.

Key Phrase Explanation
execute calculation <calc-name> Run the specified stored calculation script.
<calc-name> on database Run the specified stored calculation script against the specified database.
<calc-string> on <dbs-name> Run an anonymous calculation, whose body is contained in <calc-string>, against the specified database.
default on <dbs-name> Run the default calculation against the specified database.

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