Data items

Data items are located on the Design tab in the Report Designer area of the screen. Data items are considered subgroups and contain information about the specific module. When designing a report template, you will drag different types of data items into the Excel worksheet, and these fields form the basis for the data presented in the report.

Figure: Data items in the Report Designer

The three types of data items are:

Dimensions

• Dimensions represent a table in the connected system. If you expand the dimension by clicking the button to the left of the dimension name, all attributes belonging to the dimension are displayed. All dimensions can be used as filters, for grouping, or pulled out as fields to be displayed in the report.

Attributes

• Attributes represent a descriptive field in the transaction table for the connected system. All attributes can be used as filters, for grouping, or pulled out as fields to be displayed in the report.

Measures

• Measures represent a value field in the transaction table for the connected system. Measurement values can be used as a filter or pulled out as fields to be displayed in the report.

NOTE: The different types of data items will trigger certain functions, such as grouping or filters found in the Layout Editing window.