To retrieve data from the Sample Interntl database:
Select the Sample Interntl database, and then click OK.
The Essbase installation also includes sample spreadsheet files that illustrate currency conversion concepts.
From EPM_ORACLE_HOME/products/Essbase/EssbaseClient/client/sample, open Local.xls.
The worksheet contains actual (Act) and budget (Bud) data entered in local currencies for New York and Germany.
From EPM_ORACLE_HOME/products/Essbase/EssbaseClient/client/sample, open Convert.xls.
Select Essbase, and then Retrieve.
The worksheet contains values for Actual and Budget as they are displayed after conversion.
The worksheet contains data that is converted to U.S. dollars. Values for New York remain the same, but German values are converted. Essbase converts the values by using the exchange rates from the Sample Xchgrate database.
From EPM_ORACLE_HOME/products/Essbase/EssbaseClient/client/sample, open Rates.xls.
The worksheet contains all possible combinations of exchange rate scenarios, categories, and types by month. Because this example converts to U.S. dollars (USD), the sample file contains a base rate of 1 for USD. Therefore, the local and converted figures remain the same for New York. Essbase converts the figures for Germany, however, by using data values in the currency database, as follows:
Essbase divides data values from Actual by values in the Act xchg currency type.
Essbase divides data values from Actual @ Bud xchg by values in the Bud xchg currency type.
Essbase divides data values from Budget by values in the Bud xchg currency type.
Essbase bases all figures in Convert.xls on the CurCategory of P&L and the CurTime of Jan.