Converting Currencies in Report Scripts

You can convert currencies in report scripts, using the CURRENCY command to set the output currency and the currency type. For the syntax and definitions of Report Writer commands, see the Oracle Essbase Technical Reference.

Note:

Essbase cannot perform ”on the fly” currency conversions across transparent databases. If two transparent partition databases are calculated using different conversions, you cannot perform currency conversions in reports.

The following Sample report contains first-quarter Budget Sales for colas, using the January exchange rate for the Peseta currency.

Illinois Sales Budget
         Jan       Feb       Mar
         ========  ========  ========
100-10   3         3         3
100-20   2         2         2
100-30   #MISSING  #MISSING  #MISSING
100      5         5         5

           Currency: Jan->Peseta->Act xchg
           Currency: Jan->Peseta->Act xchg

Illinois Sales Budget 
         Jan        Feb       Mar
         ========   ========  ========
100-10   3          3         3
100-20   2          2         2
100-30   #MISSING   #MISSING  #MISSING
100      5          5         5

Use the following script to create the Sample currency conversion report:

<Page (Market, Measures, Scenario)
{SupCurHeading}
Illinois Sales Budget
  <Column (Year)
  <children Qtr1
<Currency "Jan->Peseta->Act xchg"
<Ichildren Colas
  !
{CurHeading}
Illinois Sales Budget
  <Column (Year)
  <children Qtr1
  !