CCONV

Calculates currency conversions. This command is available only if your company has purchased the Currency Conversion option.

Syntax

CCONV currExchMbr | TOLOCALRATE curType;
Parameter Description

currExchMbr

Currency name containing the required exchange rate. This is a member from the currency database.

TOLOCALRATE

Converts a converted currency back to the original, local rate.

curType

Currency type. This is a member from the CurType dimension in the currency database.

Notes

You convert data values from a local to a common, converted currency using the CCONV currExchMbr command. For example, you might convert data from a European currency into US$. You can then convert the data values back to the local currency using the CCONV TOLOCALRATE curType command.

Note:

The CCTRACK setting in the essbase.cfg file must be set to TRUE (the default) to enable the CCONV TOLOCALRATE command.

You can convert all or part of the main database using the rates defined in the currency database. You can keep both the local and converted values in the main database, or you can overwrite the local values with the converted values.

If you want to overwrite local values with converted values:

You do not need to create a CURPARTITION dimension in the main database. Use the CCONV command in a calculation script to convert all the data in the database.

Note:

You cannot use the FIX command if the CCTRACK setting is set to TRUE (the default) in the essbase.cfg file and you are not using a CURPARTITION dimension.

If you want to keep both local and converted values:

In the main database, define the members that store the local and converted values. You do this by creating a CURPARTITION dimension. The CURPARTITION dimension has two partitions, one for local values and one for converted values.

  To convert data:

  1. Use the DATACOPY command to copy data from the local to the converted partition.

  2. Use the FIX command to calculate only the converted partition and use the CCONV command to convert the data.

  3. Use the CALC command to recalculate the database.

To convert currencies, you must create a currency database and define specific dimensions in the main database. For more information, see the Oracle Essbase Database Administrator's Guide.

Example

CCONV YEN;

converts the data values from local currency values to Japanese Yen using the YEN exchange rate from the currency database.

 
CCONV TOLOCALRATE "Act xchg";

converts the data values back to the local currencies using the Act xchg currency type from the currency database.

 
CCONV Actual->US$;

converts the data values from local currencies to US$ using the Actual, US$ exchange rate from the currency database.

 
FIX (Act)
    CCONV TOLOCALRATE "Act xchg";
ENDFIX

converts the data in the Act currency partition back to the local currencies using the Act xchg currency type from the currency database.

 
DATACOPY Act TO Actual;
FIX (Actual)
    CCONV "Act xchg"->US$;
ENDFIX
CALC ALL;

copies Actual data values from the local currency partition to the converted currency partition. Fixes on the Actual data (in the converted partition) and converts it using the Act xchg, US$ rate from the currency database. Recalculates the database.

See Also