CCONV

This command is available only if you generated a currency cube to go along with your main cube. To convert currencies, you must also define specific dimensions in the main cube.

Syntax

CCONV currExchMbr | TOLOCALRATE curType;

Parameters

currExchMbr: Currency name containing the required exchange rate. This is a member from the currency cube.
TOLOCALRATE: Converts a converted currency back to the original, local rate. To use this, CCTRACK must be set to TRUE in the application configuration.
curType: Currency type. This is a member from the CurType dimension in the currency cube.

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.

You can convert all or part of the main cube using the rates defined in the currency cube. You can keep both the local and converted values in the main cube, 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 application configuration and you are not using a CURPARTITION dimension.

If you want to keep both local and converted values:

In the main cube, 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.

Use the DATACOPY command to copy data from the local to the converted partition.
Use the FIXcommand to calculate only the converted partition and use the CCONV command to convert the data.
Use the CALC ALL command to recalculate the cube.

Example

CCONV YEN;

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

CCONV TOLOCALRATE "Act xchg";

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

CCONV Actual->US$;

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

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 cube.

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 cube. Recalculates the cube.