In business applications requiring currency conversion, the Essbase database is divided into at least two "slices." One slice handles input of local data, and another slice holds a copy of this data converted to a single common currency for comparison and consolidation. Essbase holds the rates required for currency conversion in a currency database. The currency database outline, automatically generated by Essbase from the main database, typically maps a given conversion ratio onto a section of the main database.
|
Note: |
Currency conversion does not apply to aggregate storage application. |
To build a currency conversion application and perform conversions, follow this process:
If necessary, troubleshoot currency conversion.
“Designing and Building Currency Conversion Applications” in the Oracle Essbase Database Administrator's Guide