Supplying Data Directly in a Request

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.


Top of page

x
Syntax: How to Supply Data Directly in a Request
DATA value,[..., value],$ [AS 'text'] [LABEL label] OVER

where:

value
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 (,$).
AS 'text'
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.

label
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.


Example: Supplying Data Directly in a Request

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