CALCTRACE
The CALCTRACE configuration setting enables calculation tracing to help you debug Essbase calculation scripts. You can specify a single cell to trace from Smart View, or use SET TRACE commands in calculation scripts if you need to trace multiple cells.
CALCTRACE configuration applies only to block storage (BSO) databases, and does not apply to aggregate storage (ASO) databases.
The calculation tracing is done on the cell specified by using the SET TRACE calculation command, or by selecting the cell in Smart View. The output is available in Smart View, as well as in a file, calc_trace.txt
, located in the cube directory.
Syntax
CALCTRACE OFF | ON
-
OFF – Calculations are not traced. Any SET TRACE commands in calculation scripts are ignored. This is the default.
-
ON – Calculations can be traced. You can specify a cell to be traced in Smart View by selecting a cell in the grid before executing a calculation script. You can also use SET TRACE commands in calculation scripts if you need to trace multiple cells.
Example
CALCTRACE ON