Adding a vertical list
You can use the user interface to add an
INFOR.GET.ELEMENT
formula to create a vertical list in your report.
-
Select a cell in which 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.
-
Click Vertical
Elements.
After you select to add vertical elements, you can easily switch between the vertical and horizontal list in the top right section of the page.On the Add Vertical Elements page, you can easily switch from the vertical to a horizontal list through the button in the top right section of the page.
- Select a data connection.
- Select a cube.
- Select dimension or hierarchy.
-
Optionally, instead of selecting a data source element, click
the Reference a cell
icon to select a reference cell.
The reference cell must contain a valid unique name for the corresponding data source. You can only use a single cell reference.
-
To change the display format, click the Display list and select a
different display option.
By default, the element caption is selected. You can select any other element attribute to be displayed.
-
Optionally, use the Custom option in the Reference list to connect a
single column of cells and use it for the element selection.
By default, element unique names are generated automatically in the cell to the right of each formula. You can turn off the automatic generation of unique names by clearing the Create Unique Name check box in the Reference drop-down list.
-
Optionally, select which elements to show:
Option Description All Elements By default, all elements of the selected hierarchy are available for selection and the default element of the hierarchy is selected. Selected Elements Only the list of selected items is displayed. If no elements are selected, the default element of the selected hierarchy is used in the report. 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. - To look for specific elements, specify the phrase in the search box and press Enter.
-
To select other elements than the default element of the
hierarchy, select the Custom
Selection option.
You can select one or more elements. To select all elements, expand the elements and select the Select all visible check box.Note: When you reference multiple cells that contain element unique names, a read-only, flat list of selected elements is shown in the Elements section.
- Click Add.