Ansicht
Dokumentation

ABENSELECT_HIERARCHY_AGG_NAVIS - SELECT HIERARCHY AGG NAVIS

SELECT, FROM hierarchy_aggregate_navigator

... HIERARCHY_DESCENDANTS_AGGREGATE( ... )
  $| HIERARCHY_ANCESTORS_AGGREGATE( ... ) ...

Effect

Specifies a hierarchy aggregate navigator as a data source data_source in an query. A hierarchy aggregate navigator accesses an SQL hierarchy and uses aggregate functions to evaluate it. The following hierarchy aggregate navigators are available:

• HIERARCHY_DESCENDANTS_AGGREGATE

• HIERARCHY_ANCESTORS_AGGREGATE