View Source

Nested subsets allow you to create a custom drill-down structure based on one attribute column. The levels of the nested subsets can be defined as standard attribute members or custom members.

Creating a nested structure

The nested structure can be defined on the screen with the subset members:

BellaDati User Documentation > Creating nested subsets > image2019-5-7 10:44:20.png

Click the button "+" to create a nested structure (add a new nested level to the subset):

BellaDati User Documentation > Creating nested subsets > image2019-5-7 10:46:54.png

Add members which will be included in the lower level of the selected attribute member (the same steps as when creating a new subset):

BellaDati User Documentation > Creating nested subsets > image2019-5-7 10:50:5.png

Click button Back to see the nested structure:

BellaDati User Documentation > Creating nested subsets > image2019-5-7 10:50:54.png

When a subset with nested values is applied in the table, drill-down is predefined based on the nested structure:

BellaDati User Documentation > Creating nested subsets > image2019-5-7 10:54:21.png

Values from the upper levels of the nested structure inherit the values from the lower levels.

Changing order of members

Users can change the order of already added member.

It can be done from the subset overview:

BellaDati User Documentation > Creating nested subsets > image2020-3-17 10:37:52.png

Or from the parent detail:

BellaDati User Documentation > Creating nested subsets > image2020-3-17 10:40:8.png

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.

BellaDati User Documentation > Creating nested subsets > image2020-2-3 15:34:58.png

The drill-down can be enabled again by clicking on the minus icon above the member.

BellaDati User Documentation > Creating nested subsets > image2020-2-3 15:35:33.png

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.

BellaDati User Documentation > Creating nested subsets > image2020-3-17 10:17:4.png

The value displayed in the report will be based on the selected aggregation:

BellaDati User Documentation > Creating nested subsets > image2020-3-17 10:20:16.png

Adding custom members to the nested structure

Using custom members in the nested structure allows you to create your own nested structure with the values which are not present in the subset attribute.

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: