Skip to content

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 ​

ParameterTypeDescription
cubeNamestringThe cube's name.
shouldEvaluatebooleanOptional. true to turn formula evaluation on, false to turn it off. Leave it out to check whether it's on.

Returns ​

boolean

Whether 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