A main database, such as Sample Interntl, usually contains values that are converted and stored in the database. You can perform currency conversions dynamically, as well. Essbase provides this capability with the Currency Report command. This command enables you to interactively change the currency rates and types applied to the retrieval.
To perform an ad hoc conversion on data in Convert.xls:
From EPM_ORACLE_HOME/products/Essbase/EssbaseClient/client/sample, open Convert.xls.
The worksheet contains data that is converted to U.S. dollars.
Select Essbase, and then Currency Report.
The Essbase Currency Report dialog box enables you to modify the exchange rates applied to the retrieval interactively, with options for currency settings, names, categories, and years. .
Select the currency settings to apply.
For example, select CAD from the CurName list and Bud xchg from the CurType list.
Select Essbase, and then Retrieve.
Essbase converted the New York and Germany figures to Canadian dollars (CAD).
Click Clear in Essbase Currency Report.
Performing a currency report retrieval does not change values in the database. The process performs a temporary conversion as part of the retrieval. Converted data values may not balance because the ad hoc conversion is performed on values that were previously calculated, or previously consolidated, in another currency.
If values must balance and be verified, they must be converted to the target currency in the database, calculated, and retrieved. This procedure differs from the ad hoc currency conversion retrievals described in this lesson.