Calc: Run a Calculation Script
The calc CLI command for Essbase executes a calculation script on the cube. To run this command, you need at least Database Update permission, as well as provisioned access to the calculation script.
Before you can run calculation scripts, you must first upload the scripts, as .csc files, to the cube directory. You can use the CLI to upload files. See Upload: Add Cube Files.
Syntax
calc [-verbose] -application appname -db cubename -script scriptfilename
Option | Abbreviation | Description |
---|---|---|
-verbose | -v | Show extended descriptions |
-application | -a | Application name |
-db | -d | Database (cube) name |
-script | -s | Calculation script name. Must have .csc file extension. You do not need to give a full path. Files are assumed to be in the relevant cube directory.
|
Example
esscs calc -v -a Sample -d Basic -s CALCALL.CSC
You can also run calculation scripts using the Calculate option in Cube Designer or Smart View, Jobs in the Essbase web interface or REST API, or execute calculation in MaxL.