Filtering data in a report

You can add an INFOR.GET.ELEMENT formula to filter data in your report.
  1. Select a cell where to add the formula.
    Note: To use Excel Integration user interface to add formulas, ensure that Excel is not in cell-editing mode. Entering the edit mode results in a formula write error.
  2. Click Filter.
  3. Select a data connection from the list or click the Reference a cell icon to select a reference cell.
    The reference cell must contain a valid unique name for a data connection. For example, BIBestPr_BestPracticesOLAP. You can only use a single cell reference.
  4. Optionally, if you selected a data connection from the list and the data connection uses a Domain cube, select a domain from the list. Domains enable you to show a limited number of dimensions in the report. The default selection is No Selection.
  5. Optionally, if you selected a domain, select filter driver dimensions such as a configuration set, ledger, accounting unit, or entity.
    The filter driver dimensions differ depending on the selected domain.
  6. Select a cube from the list or click the Reference a cell icon to select a reference cell.
    The reference cell must contain a valid unique name for a cube. For example, Analysis. You can only use a single cell reference.
    Note: The selected data sources are kept in the data source pane until you refresh the add-in's user interface (UI). Right-click the UI and select Refresh.
  7. Select a dimension or hierarchy, or click the Reference a cell icon to select a reference cell.
    The reference cell must contain a valid unique name for a dimension or hierarchy. You can only use a single cell reference.
  8. Optionally, click the Display Format icon and select which element attribute to display.
    By default, the element caption is selected.
  9. Optionally, click the Element Visibility icon and select which of these elements to show:
    Option Description
    All Elements By default, all elements of the selected hierarchy are available for selection.
    Selected Elements Only the list of selected items is displayed.
    Leaf Elements Only the base elements are displayed.
    Elements from Level All levels are listed from the top level to the base level. If you select Level 0, the top elements are displayed. Or, if you select Level 1, all children of one or more top elements are displayed.
  10. Optionally, click the Reference a cell icon and select the Custom option to connect a cell for use in element selection. You must select or clear at least one element to overwrite the cell's current content. Otherwise, after you click the Add button to add a filter, the cell's current content does not change.
    By default, element unique names are generated automatically in a cell below the active cell. You can turn off the automatic generation of unique names by clearing the Create unique name connection check box.
  11. To look for specific elements, click the Search icon and specify all or part of an element name in the search box.
  12. To select elements other than the default element of the hierarchy, select the check boxes of the required elements.
    You can select one or more elements. To select all visible elements, expand the elements and select the check box in the list header.
  13. Click Add.