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:“Designing and Building Currency Conversion Applications” in the Oracle Essbase Database Administrator's Guide