[IFS/BA End User Help Guide]

About IFS Business Analytics Terminology

Design Cell: Design cells are cells within Microsoft Excel spreadsheets with additional IFS defined design controls. For example, you may have cells with Zoom In, Drill Down and filter criteria defined.

Design Column: Design columns are columns within Microsoft Excel spreadsheets with additional IFS defined design controls. For example, you may have columns with filter criteria or repeaters defined.

Design Row: Design rows are rows within Microsoft Excel spreadsheets with additional IFS defined design controls. For example, you may have rows with filter criteria or repeaters defined.

Display Item: Display items are measures or dimension items used within a Microsoft Excel spreadsheet.

Drill Down: The drill down feature will allow the user to view the underlying data/data source related to a value. For example, you can perform a drill down from general ledger balances to general ledger transactions, which is the source for the general ledger balances.

Information Source: An information source holds information about a specific transaction table within IFS Applications and related dimension data (i.e. general ledger balances, budget template transactions). The star schema design is used to define information sources.

Filter Criteria: Filter criteria is used to limit the number of transactions/records displayed according to a specified selection criteria. For example, a filter criteria can be defined to display transaction relating to the current accounting year only.

Grid: Grids are areas of information in a spreadsheet that contains rows, columns and cells.

Pane: A dialog window that gives users a convenient way to use commands and modify their documents. A pane can contain one or more pages, and each page is broken up into sections and/or tabs. IFS Business Analytics uses the Document Actions Pane.

Repeater: Repeaters are used to repeat rows and columns in a Microsoft Excel worksheet. A row/column will be repeated based on the display item selected for the repeater. For example, if the row repeater selected is account, then the report will display all the accounts available in the database.

Report Book: Report books are Microsoft Excel workbooks with additional IFS defined design controls. For example, you may have columns with filter criteria or parameters defined.

Report Sheet: Report sheets are Microsoft Excel spread sheets with additional IFS defined design controls.

URL: URL, the abbreviation for Uniform Resource Locator, in IFS Business Analytics relates to a window of IFS Applications.

Zoom In:  Zoom-in will enable you to perform a detailed break down within the same information sources (data source). For example, if you perform zoom-in on a  general ledger balance amount then you can view the related general ledger information such as code part information and year-period information.