Glossary
ACROSS field

Horizontally sorts and groups data in a report by the values in the selected field. You can sort a report by more than one field.

BAR

A row type in Financial Report Painter. You can place an underline beneath a column of numbers in a financial report.

BY field

Vertically sorts and groups data in a report by the values in the selected field. You can sort a report by more than one field.

cell

A box formed by the intersection of a row and a column. This is an individual container where you enter information.

children

Values that are subordinate to a parent value in a hierarchy.

column

Vertical orientation of cells defined by a common category.

conditional formatting

The process where a condition is applied to one or more cells in a financial report.

DATA

A row type in Financial Report Painter. You can supply data (such as exchange rates or inflation rates) directly to a row for calculation purposes in a financial report.

data source

See Master File.

data value

A value that can either be supplied by a Master File or entered directly into a financial report through the DATA dialog box.

Design matrix

The environment where you create financial reports.

DETAIL field

Displays data in a report without sorting or grouping the values.

Financial Modeling Language (FML)

The underlying modeling language of Financial Report Painter.

Financial Report Painter

A Developer Studio tool. You can perform financial analysis using the Financial Report Painter, a graphical interface for the Financial Modeling Language. The Financial Report Painter enables you to perform sophisticated row-based calculations on data.

FOR field

Structures financial reports row-by-row in the Financial Report Painter.

hierarchy

The parent/child relationship between fields. The relationship is defined in the Master File.

HOLD file

The output of a report request stored in a file that you can use as input to another WebFOCUS procedure.

label

The identification for a row. You can replace the default row identification label with an explicit row label that you want to reference in an expression.

Master File

Describes the data source from where you are reporting. The Master File is a map of the data source and all of the fields. By looking at the Master File, you can determine what fields are in the data source, what they are named, and how they are formatted. You can also determine how the fields in the data source relate to each other.

Matrix

The tab located at the bottom of the Financial Report Painter. You can access your report information and build a financial report in a spreadsheet environment.

OR

Sums the value of two or more tags in a single report row in FML. Used in the FOR phrase.

parent

A value that supersedes other values attributed to it in a hierarchy.

PICKUP

A row type in Financial Report Painter. You can retrieve posted rows from a work file and use them as if they were provided in a TAG row.

RECAP

A tow type in Financial Report Painter. You can place an expression composed of numbers and operators (for example, alphanumeric, Boolean, and conditional) in a financial report.

row

A horizontal orientation of cells defined by a common category.

SUM field

Provides a total of all values for the selected numeric field when the report is executed.

TAG

A row type in Financial Report Painter. You can insert parent and/or child values from a hierarchy, which are tagged (for example, 1100, 1200, 2100), into a financial report.

TEXT

A row type in Financial Report Painter. You can insert free text or a blank row into a financial report.

title

The definition of a row. Definitions can be supplied by a Master File or customized in Financial Report Painter.

TO

Sums the value of a range of tags in a single report row in FML. Used in the FOR phrase.


WebFOCUS