Creating a nested structure
The nested structure can be defined on the screen with the subset members:
Click the button "+" to create a nested structure (add a new nested level to the subset):
Add members which will be included in the lower level of the selected attribute member (the same steps as when creating a new subset):
Click button Back to see the nested structure:
When a subset with nested values is applied in the table, drill-down is predefined based on the nested structure:
Changing order of members
Users can change the order of already added member.
It can be done from the subset overview:
Or from the parent detail:
disabling drill-down of selected MEMBER
It is possible to disable the drill-down of a selected member in the nested subset. In that case, the user won't be able to see the child members but the actual indicator value of the selected member will be calculated based on the values of the children.
The drill-down can be disabled by clicking on the plus icon above the member.
The drill-down can be enabled again by clicking on the minus icon above the member.
Changing the type of aggregation
If the member of the nested subset has at least one child (nested member), it is possible to set the aggregation type of children. By default, the value of the parent will be calculated as a sum of all the children. However, users can change the settings for each child independently, so that subtraction will be used instead of addition.
To change the aggregation type, users have to click on the parent to open the detail. In the detail, users can change the aggregation for each child.
The value displayed in the report will be based on the selected aggregation:
Adding custom members to the nested structure
New custom members can be created directly in the subset definition:
- Enter the new custom member value:
- Click the link containing "Custom value":
- Click the button Add to add the new custom member to the subset: