Advanced Member Selection by Data Source

Data Source

Advanced Member Selection Method

Essbase

  • 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

  • Select Attribute

  • 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

See SAP BW.

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

See Financial Management.

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 the implications of the relational hierarchy in advanced member selections on relational data sources. When the highest ancestor is selected, a default dimension member may be used instead of the aggregation. The relational hierarchy may also equate Also Select Children and Also Select Descendants for example.

Advanced member selection methods depend on your data source implementation.