Currency Properties

Note:

Currency properties apply to Oracle Essbase block storage databases only.

Currency properties in the following areas:.

  • Currency database—Currency database whose properties you want to view and edit. (All of the currency databases available in the application are in the list.)

  • Conversion method—How to convert currencies

  • Default currency type member—Currency type member to use as a default in currency conversions. You can specify any valid member of the CurType dimension in the currency database.

A Currency database always consists of the following four dimensions:

  • Country—Stores rates for each local currency (for example, U.S. dollars, Canadian dollars, Germany Euro).

  • Time—Typically the same as the time dimension in the main database. This allows the currency database to track currency fluctuations over time, and to accurately convert different time slices of the main database.

  • Category—Allows you to apply different rates to members of the dimension tagged as accounts in the main database. The categories defined for the accounts dimension are used to form the members in the currency category dimension of the currency database. For example, it may be necessary to convert Gross Profit and Net Profit using one category of rates, while other accounts use a different set of rates.

  • Currency Partition—Allows different scenarios for currency conversion. For example, companies may wish to store Actual Rates and Plan Rates. To convert data between scenarios, select which type of rate to use.