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.
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 !