SET CCTRACKCALC

The SET CCTRACKCALC calculation command specifies whether Essbase checks the flags set by the CCTRACK configuration setting to determine if the currency data has already been converted.

By default, CCTRACK is turned on. Essbase tracks which currency partitions have been converted and which have not. The tracking is done at the currency partition level: a database with two partitions would have two flags that could be either "converted" or "unconverted." Essbase does not store a flag for member combinations within a partition.

When you load or clear data in a currency partition, Essbase does not reset the CCTRACK flag to "unconverted". You can use SET CCTRACKCALC OFF to force the conversion of the reloaded data, ignoring CCTRACK.

Syntax

SET CCTRACKCALC ON | OFF;

Parameters

ON: Uses the flags set by the CCTRACK setting to determine whether the data needs to be converted. The default value is ON.
OFF: Always converts the data, regardless of whether CCTRACK has flagged the data as already-converted. Note that during the conversion CCTRACK is still active and tracks the exchange rates used during the conversion.

Notes

The SET CCTRACKCALC command is valid only when CCTRACK is set to TRUE (the default).

Example

SET CCTRACKCALC OFF;
FIX(Actual)
CCONV "XchR"->US$;
ENDFIX
CALC ALL;

Fixes on the the Actual currency partition and forces the conversion of the Actual data regardless of whether Essbase has flagged the data as already being converted, converting the data using the XchR, US$ rate from the currency database. Recalculates the database.