1. Configuration Reference for Oracle Essbase
  2. Essbase Configuration Settings
  3. Config Settings List
  4. CCTRACK

CCTRACK

This configuration setting controls whether exchange rates are tracked as Essbase 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. This is the default.

  • FALSE—Turns off the tracking system.

Description

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 grid client or Report Writer

  • Allows you to convert a converted currency back to its original, local rate using the 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 calculation 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 command 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 calculation 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

SET UPTOLOCAL (calculation command)

SET CCTRACKCALC (calculation command)

CLEARCCTRACK (calculation command)