Data items

Data items can be found in the Design tab in the Report Designer area of the screen. Data items are considered to be sub-groups and contain information pertaining to the specific module. While designing a report template, you will drag different types of data items into the Excel worksheet.

Figure: Data items in the Report Designer

 

The three types of data items are:

Dimensions

 Dimensions represent a table in the connected database. If the dimension is expanded by clicking the button to the left of the dimension name, all attributes of the dimension will be displayed. All attributes and dimensions can be used as filters or displayed in the report view.

 

Light dimensions

Light dimensions represent a descriptive field in the transaction table of the connected database. Light dimensions can be used as a filter or displayed in the report view.

 

 Measures

Measures represent a value field in the transaction table of the connected database. Measures can be used as a filter or displayed in the report view.

 

[icon name=”lightbulb-o” class=”” unprefixed_class=””] NOTE: The different types of data items will trigger certain features, such as, grouping or filters.