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:

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:

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:

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

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:

  1. Enter the new custom member value:
  2. Click the link containing "Custom value":
  3. Click the button Add to add the new custom member to the subset:

 

  • No labels