How to: |
In certain cases, you may need to include additional constants (such as exchange rates or inflation rates) in your model. Not all data values for the model have to be retrieved from the data source. Using FML, you can supply data directly in the request.
DATA value,[..., value],$ [AS 'text'] [LABEL label] OVER
where:
Without this entry, the row title is blank on the report.
In this example, two values (.87 and 1.67) are provided for the exchange rates of euros and pounds, respectively:
DEFINE FILE LEDGER
EUROS/I5C=AMOUNT;
POUNDS/I5C=3.2*AMOUNT;
END
TABLE FILE LEDGER
SUM EUROS AS 'EUROPE,DIVISION'
POUNDS AS 'ENGLISH,DIVISION'
FOR ACCOUNT
1010 AS 'CASH--LOCAL CURRENCY' LABEL CASH OVER
DATA .87, 1.67 ,$ AS 'EXCHANGE RATE' LABEL EXCH OVER
RECAP US_DOLLARS/I5C = CASH * EXCH;
END
The values supplied are taken one column at a time for as many columns as the report originally specified.
The output is shown in the following image.
EUROPE ENGLISH DIVISION DIVISION -------- -------- CASH--LOCAL CURRENCY 8,784 28,106 EXCHANGE RATE .87 1.67 US_DOLLARS 7,642 46,937
Information Builders |