Custom Hierarchy in ABAP CDS

[THENNARASU]

Hi All,

I'm working on creation of Query CDS which is used in SAC/AFO for building dashboards. In this we want to Implement a Hierarchy in a particular field I have created a custom table where I have maintained the hierarch nodes accordingly.

I  want consume this hierarchy through the CDS to AFO/SAC.
I have tried using annotations in base cube like this ,

I defined the hierarchy in a cds with self association. and through annotations I imported the hierarchy on field called ZdimGrpaccnt.

Then I consumed this CDS in a Query CDS.

While consuming it in AFO the hierarchy is not enabled on the column.


Also I tried through define hierarchy Approach. It is also not working

While testing the hierarchy through the Class and table function, I'm getting the hierarchy as needed.

Can Somebody please suggest how to achieve hierachy in AFO/SAC in this scenerio.
please provide some detailed steps of what needs to be done.


Many Thanks in Advance,
Regards,
Arasu

[gowripujithakapu]

Hi @THENNARASU, have you found any answer for your query as even iam facing the same issue

[THENNARASU]

Hi @gowripujithakapu, Sadly No I haven't received any, As an alternative I tried to Create a Hierarchy with Functional help and tried to consume it, but it hasn't helped me in my scenerio

[MKreitlein]

Hello @THENNARASU @gowripujithakapu 

I'm not sure, but it seems, you have not found this support page?

https://wiki.scn.sap.com/wiki/display/BI/Using+Hierarchy+in+CDS 

It seems in your Query cds view, you are missing the annotation:  @Consumption.filter.selectiontype: #HIERARCHY_NODE

Hopefully, you find some more helpful information there?!

BR, Martin

[gowripujithakapu]

I have developed using the link but still custom hierarchy cds is not working

[gowripujithakapu]

In mycase, it worked by using standard hierarchy cds node instead of custom one.