Top >
Essbase.CFG Configuration Settings >
CCTRACK
CCTRACK
Controls whether exchange rates are tracked as Analytic Services calculates currency conversions.
This setting does not apply to aggregate storage databases.
Syntax
CCTRACK TRUE | FALSE
TRUE |
Exchange rates are tracked while conversions are calculated. The default value is TRUE. |
FALSE |
Turns off the tracking system. |
Description
CCTRACK controls whether exchange rates are tracked while Analytic Services 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 TOLOCALRATE 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.
Notes
- 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 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.
Example
CCTRACK TRUE
See Also
CCONV (calculation command)
SET UPTOLOCAL (calculation command)
SET CCTRACKCALC (calculation command)
CLEARCCTRACK (calculation command)