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;