Adding a value

You can add value to a selected cell in your report. If you enable writeback for the new value, INFOR.GET.VALUE formula is added to the selected cell. If you disable writeback, an INFOR.READ.VALUE formula is added. If you select multiple elements, the sum of selected elements is displayed in the cell.
  1. Select a cell in which to add the formula.
    Note: To use Excel Integration to add formulas, ensure that Excel is not in cell-editing mode. Entering the edit mode results in a formula write error.
  2. Click One Value.
  3. Select a data connection.
  4. Select a cube.
  5. 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.
  6. Select how to define coordinate elements:
    Option Description
    Add Coordinate from Cell Select the coordinates from a cell.
    Select Elements from Hierarchy The default element of the selected hierarchy is selected. To change the element, click the hierarchy and 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 option. You can also use the search box to look for specific elements.
    If the pane is narrow you might not see both panels. To expand the elements panel, click the arrow that is located next to the hierarchy.
  7. To search for a dimension or a hierarchy, specify the search term in the search box that is located above the dimensions and press Enter.
    Click Show to view hierarchies that do mot match your search term and are filtered out.
  8. To select elements manually, expand the dimension, select the hierarchy, and select elements from the hierarchy.
    You can only select one hierarchy for each dimension.
  9. 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.
    Note: Changing the display format does not affect the generated formula.
  10. Click Add.