After you create a currency conversion application, you convert data values from a local currency to a common, converted currency using the CCONV command in calculation scripts. For example, you might convert data from a variety of currencies into US$. You can convert the data values back to the original, local currencies using the CCONV TOLOCALRATE command.
You can convert all or part of the main database using the rates defined in the currency database. You can overwrite the local values with the converted values, or you can keep both the local and converted values in the main database, depending on your tracking and reporting needs.
Note: | When you convert currencies using the CCONV command, the resulting data blocks are marked as dirty for the purposes of Intelligent Calculation. This means that Essbase recalculates all the converted blocks when you recalculate the database. |
To see sample currency conversion calculation scripts, see the Oracle Essbase Technical Reference.
cconv (calculation command) in the Oracle Essbase Technical Reference
set uptolocal (calculation command) in the Oracle Essbase Technical Reference
currency (report command) in the Oracle Essbase Technical Reference
set cctrackcalc (calculation command) in the Oracle Essbase Technical Reference
clearcctrack (calculation command) in the Oracle Essbase Technical Reference