The Editor section shows two sub sections:
- A box titled – Measures
- 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.
Figure 2: Measures on Editor
Click Measure and select the source field in the property pop-up as shown in Figure 3.
Click 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.
Figure 3: Measure Properties Pop-up
Drag the Query Object with qualitative fields to the Dimension area.
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.
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 icon if you want to make any changes to the selected Query Object. The query object can be removed by clicking .
Figure 6: Query Object Properties Pop-up
Click or to 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 .
Click the cross 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:
Figure 7: Analytical Object