Show TOC

Procedure documentationSpecifying Single Values Locate this document in the navigation structure

 

You can use a list of proposed values to define a characteristic as a single value and insert it into the matrix.

Procedure

  1. Place the cursor on the cell in which you want to insert a characteristic value.

  2. On the Data Matrix tab, click Single values and then select a characteristic

    A dialog box opens with a list of values for the characteristic. Depending on the characteristic that you are defining, values for other characteristics that you have already specified, and on which the values in the proposal list are dependent, may appear in the fields at the top of the box.

    Note Note

    You may want to specify a value for a characteristic that is dependent on the values of characteristics that you have not yet specified. To generate a list of valid proposals, you need to specify these delimiting characteristic values. An example of a delimiting characteristic value is the consolidation chart of accounts, which represents a compound of the characteristic FS item. A value list for FS items is displayed only after you have specified the chart of accounts.

    End of the note.

    Note Note

    If a list is very long, first, a condensed form of the list is displayed, which you can selectively expand as required.

    End of the note.

  3. Select one or more values.

    You can use Windows selection functions to select multiple values (CTRL + click) or blocks of values (SHIFT + click). You can also use the search function by ID values or long texts to go to its position in the list. In addition, you can position on a value using the Position button.

  4. Optional: To insert more than one single value, specify how you want the values to be arranged on the worksheet:

    • Vertically: multiple values in a single column. This option is useful when you are defining rows of a matrix.

    • Horizontally: multiple values in a single row. This option is useful when you are defining columns of a matrix.

  5. Click OK.

Result

The values are inserted at the cursor position, either vertically or horizontally (depending on the arrangement selected).

If you select multiple values, these values are inserted in the sequence in which they are listed in the database.

You can format, move, delete or change single values after insertion into a worksheet.

Note Note

You can define multiple single values in a single step.

End of the note.