To overwrite local values, you need not create a currency partition dimension in the main database. Use the CCONV command in a calculation script to convert all data in the database:
The following calculation script converts the values in the database to USD:
CCONV USD; CALC ALL;
If required, you can specify a currency name that contains the required exchange rate. The following calculation script converts the values in the database to USD, using the exchange rate for Jan as defined in the currency database:
CCONV Jan->USD; CALC ALL;
The CALC ALL command is required in the examples shown because the CCONV command converts only currencies. It does not consolidate or calculate members in the database.
The following calculation script uses the “Act xchg” rate to convert the converted values back to their original local currency values:
CCONV TOLOCALRATE "Act xchg"; CALC ALL;