SET REMOTECALC

For applications with transparent partitions, turns remote calculation to the source on or off.

Syntax

SET REMOTECALC ON | OFF;
Parameter Description

ON

Default. Essbase connects to the source partition enabling remote calculations.

OFF

Essbase does not connect to the source partition. Use this option only when absolutely sure the calculation script does not involve access to remote data.

Notes

  • When you are working with transparent partitions and are sure that a calculation script does not include remote values in the calculations, you can use SET REMOTECALC OFF to improve calculation performance.

  • Performance improvement is visible only when batch calculation is run on the target application.

Example

SET REMOTECALC ON;

SET REMOTECALC OFF;

See Also