SET REMOTECALC

The SET REMOTECALC calculation command for Essbase turns on or off the ability to perform remote calculation to the source of a transparent partition.

Syntax

SET REMOTECALC ON | OFF;

Parameters

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;