SET CCTRACKCALC

Specifies whether Essbase checks the flags set by the CCTRACK 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 "uncoverted". You can use the SET CCTRACKCALC OFF command to force the conversion of the reloaded data, ignoring the CCTRACK flag.

Syntax

SET CCTRACKCALC ON | OFF;
Parameter Description

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.

See Also