CURRENCY

Converts data values in the report to the targetCurrency, and causes the currency heading to be displayed with the page heading. This does not convert the data in the database: only in the report.

If the <CURRENCY command is not used, the data is reported as it is currently stored in the database. Typically, the database is set up with currency conversions, requiring no additional conversion.

Syntax

<CURRENCY targetCurrency

Parameter	Description
targetCurrency	Currency and currency type to display in the report. Currency type is optional. Up to four members (at most one from each currency database dimension) in a cross-dimensional member (->) For example:USD, or USD->Actual->Jun99

Parameter

Description

targetCurrency

Currency and currency type to display in the report. Currency type is optional. Up to four members (at most one from each currency database dimension) in a cross-dimensional member (->)

For example:USD, or USD->Actual->Jun99

Notes

The currency conversion label, which identifies the currency used in the report, appears at the top of each page. See the TEXT command for custom placement of the currency label.
For information on creating and maintaining currency databases, see the Oracle Essbase Database Administrator's Guide.

Example

<PAGE (Market, Measures, Scenario)
Illinois Sales Budget
 <COLUMN (Year)
 <CHILDREN Qtr1
<CURRENCY USD
<ICHILDREN Colas
     !

This example produces the following report:

Currency: USD
                   Illinois Sales Budget 
                      Jan        Feb        Mar
                 ========   ========   ========
100-10                360        370        380
100-20                240        260        280
100-30           #Missing   #Missing   #Missing
  100                 600        630        660