Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Sv translation
languageen
Info

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:

Info

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:

Image Added

Or from the parent detail:

Image Added

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.

Image Added

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

Image Added

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.

Image Added

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

Image Added 

Adding custom members to the nested structure

Info

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:

 

...

Sv translation
languageja


Info

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.

ネスト構造の作成

ネストされたサブセットを使用すると、1つの属性列に基づいてカスタムドリルダウン構造を作成できます。ネストされたサブセットのレベルは、標準属性メンバーまたはカスタムメンバーとして定義できます。

ネスト構造の作成

ネスト構造は、サブセットメンバーを使用して画面上で定義できます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ネストされた値を持つサブセットがテーブルに適用されると、ネスト構造に基づいてドリルダウンが事前定義されます:

Info

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

 

ネスト構造へのカスタムメンバの追加

Info

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:
    Image Removed
  2. Click the link containing "Custom value":
    Image Removed
  3. Click the button Add to add the new custom member to the subset:
    Image Removed
 

ネスト構造の上位レベルの値は、下位レベルの値を継承します。


選択したメンバーのドリルダウンの無効化

ネストされたサブセット内の選択されたメンバーのドリルダウンを無効にすることができます。その場合、ユーザーは子メンバーを見ることができませんが、選択されたメンバーの実際のインジケータ値は、子の値に基づいて計算されます。

ドリルダウンを無効にするには、メンバーの上にあるプラスアイコンをクリックします。

Image Added

メンバーの上にあるマイナスアイコンをクリックすると、ドリルダウンを再び有効にできます。

Image Added

ネスト構造へのカスタムメンバーの追加

Info

ネスト構造でカスタムメンバーを使用すると、サブセット属性に存在しない値を使用して、独自のネスト構造を作成できます。


新しいカスタムメンバーは、サブセット定義で直接作成できます:

  1. 新しいカスタムメンバー値を入力します:
    Image Added
  2. [カスタム値]を含むリンクをクリックします:
    Image Added
  3. [追加]ボタンをクリックして、新しいカスタムメンバーをサブセットに追加します:
    Image Added