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
Specifies the values that you are supplying. Values in a list must be separated by commas. The list must end with a comma and a dollar sign (,$).
Enables you to assign a title to the data row. Enclose the text in single quotation marks.
Without this entry, the row title is blank on the report.
Assigns a name to the data row for use in RECAP calculations. The label can be up to 66 characters and cannot have blanks or special characters. Each explicit label you assign must be unique.
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.