Intellicus Enterprise Reporting and Business Insights 19.1

Adding Measures and Dimensions

0 views June 28, 2020 0

The Editor section shows two sub sections:

  1. A box titled – Measures
  2. A canvas area for dropping Dimensions on

Drag the Query Object with quantitative fields from Query Object Selector into the Measures box.

Now it shows that Measures is ‘sourced’ by the selected Query Object.

Measures on Editor
Figure 2: Measures on Editor

Click Measure and select the source field in the property pop-up as shown in Figure 3.

Click edit icon to turn Edit Mode on. You can click + to add measures to the analytical object definition.

You can also click + in front of the query object name to add a Measure Group. A measure group contains measures which belong to the same underlying fact table.

Measure Properties Pop-up
Figure 3: Measure Properties Pop-up

Drag the Query Object with qualitative fields to the Dimension area.

Dimension on Editor
Figure 4: Dimension on Editor

Now a dimension is created with the dragged Query Object as source.

Next you need to select Hierarchy item and set the Hierarchy name in the property tab of dimension.

Click Level under Hierarchy to select Level item. Specify the Level source field from the source Query Object and set the level name.

An integral part of creating aggregations is to create and maintain the appropriate attribute relationships for your hierarchies.

The joining line appears in red color till the time relation between measure and dimension is not set.

Select the line and set the key joining measure to dimension.

As soon as you set the key, the line turns blue.

We will discuss the properties of measure, dimension, hierarchy, level and attribute later in this document.

Relation between Measure and Dimension
Figure 5: Line showing Relation from Measure to Dimension

You can add multiple measures each sourcing a field from the Query Object.

You can add multiple dimensions by dragging multiple Query Objects on the dimension area. It helps to create levels if you drag the fields inside an existing dimension.

The fields can be added to the Editor by either of the following ways:

  • Dragging and dropping a field from under Fields pane as measure/dimension/attribute/hierarchy
  • Clicking the + sign under Edit Mode to add measure, level or attribute on the Editor area. You can specify a field on the properties pop-up window on clicking the newly added measure, level or attribute.
  • You can click the query object name (for measure or dimension) to list the fields in a pop-up window as shown in Figure 6. Right-clicking the field would add the field as measure, level or attribute

On the same pop-up, click the Edit Query Edit Query icon icon if you want to make any changes to the selected Query Object. The query object can be removed by clicking remove edit query icon.

Query Object Properties
Figure 6: Query Object Properties Pop-up

Click arrow icon or  arrow iconto respectively expand or collapse the measure, level or attribute.

In Edit mode, you can select a field and move them up and down using the arrow keys arrow icon arrow icon.

Click the cross cross icon icon  in front of the respective field to remove a measure, measure group, hierarchy, level or attribute.

A sample Analytical Object shall look like below:

Analytical Object
Figure 7: Analytical Object