cube.formulaEvaluation
Turns a cube's formula evaluation on or off.
js
cube.formulaEvaluation(cubeName, shouldEvaluate)
cube.formulaEvaluation(cubeName)Turning it off speeds up loading lots of data, because formulas aren't recalculated after every write. Remember to turn it back on afterwards.
Parameters
| Parameter | Type | Description |
|---|---|---|
cubeName | string | The cube's name. |
shouldEvaluate | boolean | Optional. true to turn formula evaluation on, false to turn it off. Leave it out to check whether it's on. |
Returns
booleanWhether formula evaluation is on.
Examples
js
cube.formulaEvaluation("Profit and Loss", false); // Turn formula evaluation off
// Do some heavy data input...
cube.formulaEvaluation("Profit and Loss", true); // Turn it back on