Hierarchical Functions

These functions are used for building or deriving member elements or lists or 'sets' in the data model based on positioning in a regular hierarchy.

  • Family: MDX
  • Library: Semantic

    • Function List

    ◉ Compatible with SAP BW

    Ascendants

    ◉

    2018.00.000

    Children

    ◉

    2018.00.000

    Cousin

    ◉

    2018.00.000

    Descendants

    ◉

    2018.00.000

    Dimension

    ◉

    2018.00.000

    Dimensions

    ◉

    2018.00.000

    DrilldownLevel

    2018.00.000

    DrilldownLevelBottom

    ◉

    2018.00.000

    DrilldownLevelTop

    ◉

    2018.00.000

    DrilldownMember

    ◉

    2018.00.000

    DrilldownMemberBottom

    ◉

    2018.00.000

    DrilldownMemberTop

    ◉

    2018.00.000

    DrillupLevel

    ◉

    2018.00.000

    DrillupMember

    ◉

    2018.00.000

    FirstChild

    ◉

    2018.00.000

    FirstSibling

    ◉

    2018.00.000

    Hierarchy

    ◉

    2018.00.000

    LastChild

    ◉

    2018.00.000

    LastSibling

    ◉

    2018.00.000

    Level

    ◉

    2018.00.000

    Levels

    ◉

    2018.00.000

    Ordinal

    ◉

    2018.00.000

    Parent

    ◉

    2018.00.000

    RollupChildren

    2018.00.000

    Root

    2018.00.000

    Siblings

    ◉

    2018.00.000