How to use a CDS hierarchy defined with "define hierarchy" as a analytical CDS dimension?

[WRoeckelein]

Hi all,

has anyone an example on how to use a CDS hierarchy defined with "define hierarchy" as a analytical CDS dimension? I only found examples without using CDS hierarchy but only with analytical hierarchy annotations.

Thanks,

Wolfgang

[WRoeckelein]

ingo.braeuninger Do you have an idea who could help here?

[Andre_Fischer]

Hi Wolfgang,

unfortunately this is not possible yet.

In 2205 it is possible to create CDS hierarchies in ABAP language version 5, it is however not possible to use the same in analytical queries.

This is currently planned for 2208.

Kind regards,

Andre

[WRoeckelein]

Hi andre.fischer,

thanks, ok, will wait for 2208 then...

Is there also a timeline for S/4HANA onpremise available? CDS hierarchy is available since 753 (temporal hierarchy was added in 754), but when could one use these in analytical queries onpremise?

Regards,

Wolfgang

[Andre_Fischer]

Yes it is planned that this will be part of the next on premise shipment as well.

I got the information that when using „define hierarchy“ in analytics there are some known restrictions:

• structuctures may not be time-dependent
• one must not use analytics.dataExtraction

Kind regards,

Andre

[pbist0103]

DEFINE HIERARCHY can be consumed in ABAP, but for SAP Analytics you have to create using the annotations defining 3 pieces - one base entity of type dimension another that reads from the node (HRRP_NODE) of the type #HIERARCHY and the 3rd one reads from HRRP_DIRECTORY. Just check how the hierarchies for Profit Center or Cost Center are implemented it's very simple.

The base will declare the NODE as hierarchy association and the node refer back to base as a foreign key association and the node will also have an association to the CDS that reads from the HRRP_DIRECTORY. I created a custom one recently and did a lot of Googling but I don't know how to share directly here with less effort as typing takes too much time.

[WRoeckelein]

Thanks for your answer, but I do not get it. I was asking about using ABAP DEFINE HIERARCHY as an analytical (hierarchical) dimension. I can't really match your answer to this question.

[pbist0103]

As the guy from SAP mentioned DEFINE HIERRACHY won't work for Analytical CDS. So I shared the solution assuming that your need is to create an analytical CDS hierarchy. If it's a Yes and No match the answer is NO. DEFINE Hierarchy do not support CDS based analytics.