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 by the designer to create output in Excel according to the needs of the end user.
Drill Down: The drill down feature will allow the user to view detailed transactions related to a cell value. In this case the target source is another Information Source than the one used in design to present the report output. For example, you can perform a drill down from General Ledger balances to General Ledger transactions, which is the detail source for the General Ledger balances.
Information Source: An Information Source is star schema based on a Fact representing transactional values and a set of related Dimensions, normally representing basic data.
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 Reporter uses the Document Actions Pane.
Repeater: Repeaters are used to repeat rows, columns and sheets in a Microsoft Excel worksheet. A row/column/sheet 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 global filter conditions or parameters defined.
Report Sheet: Report sheets are Microsoft Excel spread sheets with additional IFS defined design controls.
Ribbon: General available options are available in the IFS Business Reporter specific Excel ribbon. The ribbon has different content in Report Mode and Designer Mode.
URL: URL, the abbreviation for Uniform Resource Locator, in IFS Business Reporter referring to a window in IFS Applications.
Zoom In: Zoom-in will enable a detailed break down of a cell value within the same Information Sources. For example, if zoom-in is performed on a General Ledger balance amount then all related General Ledger transactions can be viewed, containing detail information about the code string etc.