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 cube: only in the report.

If the <CURRENCY command is not used, the data is reported as it is currently stored in the cube.

Syntax

<CURRENCY targetCurrency

Parameters

targetCurrency

Currency and currency type to display in the report. Currency type is optional. Up to four members (at most one from each currency cube 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.

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