SAP BW Advanced Member Selection

All Members

Selects all members

Select Dim Top

Selects the highest ancestor, or, in multiple hierarchies, all top level ancestors

Select Dim Bottom

Selects all lowest level descendants

Also Select Descendants

Selects the current member and its descendants

Select Parent

Selects the parent of the current member

Also Select Ancestors

Selects the current member and its ancestors

Also Select Children

Selects the current member and its children

Also Select Siblings

Selects the current member and members on the same level and of the same parent

Also Select Level

Selects the current member and all members on the same level and of the same dimension

Select At Level

Selects all members at a level specified by name or number

Also Select Previous

Selects a variable number of previous members from the level of the current member; uses MDX LAG to indicate the number of previous members to return

Also Select Next

Selects a variable number of next members from the level of the current member; uses MDX LEAD to indicate the number of subsequent members to return

Date Time Series

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

Select Top/Bottom

Returns a variable number of members, based on their rank

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

Result sets may differ from Dimension Browser preview, due to custom filter selections on the query.

Filter on Member Properties

Displays the Member Properties dialog box, used to select member subsets by member SAP BW property values

Find in Tree

Locates members in large dimensions; expands the hierarchy but does not add found members to the Selection list