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 |
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
See Also