Execute a stored calculation, the stored default calculation (determined by alter database), or an anonymous (non-stored) calculation string.
Minimum permissions required:
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.'
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.
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 |