A dimension is an intersection of data and values. You can group data and values in Management Reporter for Microsoft Dynamics ERP with one another to classify and analyse transactions in more detail.

You can use the Insert Rows from Dimensionsdialogue box to add multiple rows to a row definition at one time. The dialogue box displays one column for each dimension. For each dimension, you can specify the following information:

Option

Description

Dimension

The pattern that identifies the dimension to add to the row definition. This pattern contains one ampersand (&) or hash (#) for each position in the dimensions. Generally, use all ampersands for the Account dimension and all hash signs for other dimensions.

Dimension Range Start

The first value for this dimension to add to the row definition.

Dimension Range End

The last value for this dimension to add to the row definition.

Add dimensions to a row definition

  1. In Report Designer, click Row Definitions, and then open a row definition to modify. On the Editmenu, click Insert Rows from Dimensions.

  2. In the Insert Rows from Dimensionsdialogue box, in the Dimensionsrow, select the cell for the dimension to be transferred to the row definition, and then click All &&&.

  3. To limit the row definition to a specific range of dimension values, type the starting dimension value in the Dimension Range Startcell, and then type the ending dimension value in the Dimension Range Endcell.

    To include all values for the selected dimension, leave these cells empty.

    Note Note

    Wildcard characters (* ?) in dimension ranges might not return all of the results that you want, depending on how the ERP database collates data.

  4. Select or type a value in the Starting row codefield to specify the row code for the first dimension value to be added to the row definition.

  5. Select or type a value in the Increment each row byfield to specify the gap between consecutive row codes. For example, if the first row code is 100 and the increment value is 30, the first several new rows have the codes 100, 130, 160, 190, and 220. Use an increment value that provides space for inserting new format and formula rows.

  6. Click OK. One line per selected dimension value is added to the row definition.

See Also