Advanced Member Selection by Data Source

Different data sources support different member selection methods.

Table 14. Advanced Member Selection by Data Source  

Data Source

Advanced Member Selection Methods

Analytic Services

  • Also Select Children

  • Also Select Descendants

  • Select Parent

  • Also Select Ancestors

  • Also Select Siblings

  • Select Dim Bottom

  • Select Dim Top

  • Also Select Level

  • Also Select Generation

  • Also Select Previous

  • Select Subset

  • Substitution Variables

  • Dynamic Time Series

  • Search

  • Find in Tree

SAP BW

  • All Members

  • Select Dim Top

  • Select Dim Bottom

  • Also Select Descendants

  • Select Parent

  • Also Select Ancestors

  • Also Select Children

  • Also Select Siblings

  • Also Select Level

  • Select At Level

  • Also Select Previous

  • Also Select Next

  • Dynamic Time Series

  • Select Top/Bottom

  • Filter on Member Properties

  • Find in Tree

Financial Management

  • All Members

  • Select Dim Top

  • Select Dim Bottom

  • Also Select Descendants

  • Member List

  • Also Select Children

  • User Defined Field

  • Search

  • Find in Tree

JDBC Relational Data Sources

  • Also Select Children

  • Also Select Descendants

  • Select Parent

  • Also Select Ancestors

  • Also Select Siblings

  • Select Dim Bottom

  • Select Dim Top

  • Also Select Generation

  • Find in Tree

Consider relational-hierarchy implications in advanced member selections on relational data sources. When highest ancestors are selected, default members, rather than aggregations, may be used. For example, the relational hierarchy may equate Also Select Children and Also Select Descendants.