Equivalent of CL_RSR_HIERARCHY~DESCENDANTS_GET for use in AMDP method

[former_member568535]

Dear all,

I can get a list of descendants of a given BW hierarchy node using CL_RSR_HIERARCHY~DESCENDANTS_GET method.

Now I need an equivalent of this method in the form of HANA Table Function or Calculation View, to use it in AMDP method.

Are there any standard Table Functions / Calculation Views serving this purpose?

Thank you,

Val

[ThorstenHoefer]

Please have a look to following example:
https://help.sap.com/docs/SAP_HANA_PLATFORM/4f9859d273254e04af6ab3e9ea3af286/77c7e749318c4f408bfe691...

SELECT
    hierarchy_rank,
    hierarchy_level,
    node_id,
    hierarchy_distance
FROM HIERARCHY_DESCENDANTS (
    SOURCE h_demo
    START WHERE node_id = 'A1'
    DISTANCE FROM 1 TO 2 )
ORDER BY
    hierarchy_rank;

[former_member568535]

This looks very much like what I actually need.

Will be back shortly with more details ...