The Financial Modeling Language (FML) is used for creating, calculating, and presenting financially-oriented data such as balance sheets, consolidations, or budgets. These reports are distinguished from other reports because calculations are inter-row, as well as inter-column.
Use the following guidelines when scheduling Financial Modeling Language (FML) reports that use the POST and PICKUP commands. Separate the POST and PICKUP steps into two procedures:
Note: Bursting an FML report is not supported since there is no BY field.
The following code creates an FML report and POSTs two tag rows to the LEDGEOUT work file. This procedure must reside on the WebFOCUS Reporting Server.
FILEDEF LEDGEOUT DISK D:\IBI\LEDGEOUT.DAT DEFINE FILE LEDGER CUR_YR/I5C=AMOUNT; LAST_YR/I5C=.87 * CUR_YR - 142; END TABLE FILE LEDGER SUM CUR_YR LAST_YR FOR ACCOUNT 1100 LABEL AR POST TO LEDGEOUT OVER 1200 LABEL INV POST TO LEDGEOUT OVER RECAP CA=R1 + R2; AS 'ASSETS' ON TABLE HOLD END
The following code retrieves the POSTed data from the LEDGEOUT work file and uses it in the RECAP calculation. ReportCaster distributes the output from this procedure.
FILEDEF LEDGEOUT DISK D:\IBI\LEDGEOUT.DAT DEFINE FILE LEDGER CUR_YR/I5C=AMOUNT; LAST_YR/I5C=.87 * CUR_YR - 142; END TABLE FILE LEDGER SUM CUR_YR LAST_YR FOR ACCOUNT 1010 TO 1030 AS 'CASH' LABEL CASH OVER DATA PICKUP FROM LEDGEOUT AR AS 'ACCOUNTS RECEIVABLE' LABEL AR OVER DATA PICKUP FROM LEDGEOUT INV AS 'INVENTORY' LABEL INV OVER BAR OVER RECAP CUR_ASSET/I5C = CASH + AR + INV; END