Controls whether exchange rates are tracked as Essbase calculates currency conversions.
This setting does not apply to aggregate storage databases.
CCTRACK TRUE | FALSE
TRUE—Exchange rates are tracked while conversions are calculated. The default value is TRUE.
FALSE—Turns off the tracking system.
CCTRACK controls whether exchange rates are tracked while Essbase calculates currency conversions. Tracking exchange rates has the following advantages:
Allows conversion to occur at report time through the Spreadsheet Add-in or the Report Writer
Allows you to convert a converted currency back to its original, local rate using the CCONV command
Prevents data inacurracies due to accidental reconversion of data during a calculation.
After loading data, you can clear the tracked exchange rates for the new data using the CLEARCCTRACK command. During a calculation, you can enable or disable CCTRACK using the SET CCTRACKCALC calculation command.
When CCTRACK is turned on the following restrictions apply:
If you are using currency partitions, you cannot use a CCONV command with a FIX statement to convert a subset of a currency partition (a calculation script attempting such a FIX will not validate).
If you are not using currency partitions, you must use CCONV with a FIX statement.
Setting CCTRACK to FALSE turns off the tracking system with the following results:
The CCONV assumes that the data is unconverted (in local currency). If you accidentally run the CCONV command multiple times on the same data, the resulting data will be inaccurate.
Similarly, the currency report options assume that the data is unconverted (in local currency). If the data has already been converted in the database, it is reconverted at report time, resulting in inaccurate data.
The restrictions on using the FIX…ENDFIX and DATACOPY commands in currency conversions do not apply. For example, if you are using currency partitions, you can now use the FIX command with the CCONV command to calculate a subset of a currency partition. If you are not using currency partitions, you can use CCONV without a FIX statement.
CCTRACK TRUE
CCONV (calculation command)
SET CCTRACKCALC (calculation command)
CLEARCCTRACK (calculation command)