SAP BW Advanced Member Selection

All Members

All dimension members. This member selection method is specific to Financial Management.

Select Dim Top

The highest ancestor, or in multiple hierarchies all top level ancestors.

Select Dim Bottom

All lowest level descendants.

Also Select Descendants

The currently selected member and its descendants.

Select Parent

The direct parent of the currently selected member.

Also Select Ancestors

The currently selected member and its ancestors.

Also Select Children

The currently selected member and its children (one level below).

Also Select Siblings

The currently selected member and members on one level with a shared parent ancestor.

Also Select Level

The currently selected dimension member and all dimension members on one level.

Select At Level

All members at a specified level of the dimension hierarchy. You can specify the level by name or number.

Also Select Previous

A variable number of previous members from the right-clicked member's level. Uses the MDX LAG command to indicate the number of previous members to return.

Also Select Next

A variable number of next members from the right-clicked member's level. Uses the MDX LEAD command to indicate the number of subsequent members to return.

Date Time Series

Time dimension members based on time definition criteria. SAP BW does not return aggregated values for DTS selections, and returns only the members that satisfy the criteria.

Select Top/Bottom

A variable number of dimension members based on their rank by another specified dimension member.

You can select the top values or the bottom values. Rank can be calculated by percentage, sum, or count. Sum uses a threshold value to select dimension members up to and including the value that exceeds the threshold.

Result sets may differ from dimension browser preview, due to the influence of custom filter selections on the query.

Filter on Member Properties

Displays the Member Properties dialog box, for selecting a subset of members by their SAP BW member property values.

Find in Tree

Locates dimension members in large dimensions. Find In Tree expands the dimension hierarchy, but does not add found members to the Selection list.