Specifies whether Analytic Services checks the flags set by the CCTRACK setting to determine if the currency data has already been converted.
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. |
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.
The SET CCTRACKCALC command is valid only when CCTRACK is set to TRUE (the default).
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.
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 |