Calculation scripts are used to define calculations that differ from those defined in the Database Outline. Calculation scripts, as described in the Database Administrator's Guide, can calculate either all or part of a database, rather than the whole-database calculation required by the outline.
Calculation commands are defined within a calculation script to instruct Analytic Services in the exact calculation rules to be used. The Calculation Script Editor is used to create a script. Within the Editor, a dialog box is available that allows you to paste functions while you develop formulas. For more information, see the Database Administrator's Guide.
When a database is created, an internal default calculation script is set to "calculate all", which means that it will calculate all dimensions based on the database outline's hierarchical relationships and formulas.
You can over-ride this default script at any time by using a custom script. You can over-ride the default script either on a temporary or permanent basis, without actually altering the default script. In the custom calc script, you can refer to calculation rules defined in the database outline or you can specify entirely new formulas, calculation formats, and calculation orders.
A calculation script contains a series of calculation commands. The order of the commands defines the execution order of the calculation.
Subscribe to:
Post Comments (Atom)
1 comment:
Calc Script details i will post it next week, Praveen Reddy, Essbase Consultant
Post a Comment