SET CCTRACKCALC

Specifies whether Analytic Services checks the flags set by the CCTRACK setting to determine if the currency data has already been converted.

Syntax

SET CCTRACKCALC ON | OFF;

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.

Description

By default CCTRACK is turned on. Analytic Services 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." Analytic Services does not store a flag for member combinations within a partition.

When you load or clear data in a currency partition, Analytic Services 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.

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 Analytic Services 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

CCTRACK (essbase.cfg file setting)
CLEARCCTRACK
CCONV
SET UPTOLOCAL

For more information on converting currencies, see the Database Administrator's Guide.

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com