A Currency Conversion application consists of two databases: a main database, which contains data in local and converted values; and a currency rates database, which contains exchange rates. Converted values are derived by applying exchange rates from the currency rates database to local values from the main database.
To facilitate ad hoc currency reporting and analysis, Essbase enables you to interactively specify the exchange rates applied to your retrieval based on the four dimensions in a currency database: a currency name dimension; a time dimension; a currency type dimension; and a currency category dimension. The Essbase Currency Report dialog box enables you to focus on currencies, time periods, scenarios, and account categories.
Current Setting Information—Enables you to indicate the current currency setting, if one exists. The setting is displayed as a list of members from the currency database. (Members in the list are separated by an arrow, ->.)
Currency Name—Select the currency types to convert data to the target currency name. If you do not select a currency name, the data is converted according to the default relationships defined in the databases.
Currency Type—Select currency types, or scenarios, those are defined in the currency database to convert data to currencies. If you do not select a currency type, the data is converted according to the default relationships defined in the databases.
Currency Time—Select to convert data to the rate of the time period. If you do not select a time period, the data is converted according to the default relationships defined in the databases.
Currency Category—Select to convert data using a list of time periods that are defined in the currency database.
Apply—Click to convert subsequent retrieval actions in a worksheet during the current session to the selected settings.
Clear—Click to reset all settings in the list boxes to (none).