How to create/show hierarchy in the custom analytical query -S/4HANA Cloud

[Sowmiya_Chinnappan]

Hi Experts,

Good Day!!

Here we have an requirement to create an hierarchy for the dimension Sponsored class in the Custom analytical query report in S/4HANA Cloud.

This custom analytical query was created on top the CDS View.

Here is the detail explanation,
Image 1:I could see the hierarchy in this analytic query which is created on top of standard CDS, then enable hierarchy to avail.

Image2: I Could't find the hierarchy for the dimensions in this analytical query created on top of the custom CDS view which we developed.

Could you please help me !

Thanks,
Sowmiya

[JulianoRomanato]

Hello sowmiya_chinnappan1.

How are you? I have excluded the Tag "SAP S/4HANA Cloud" and included the Tag "SAP S/4HANA Cloud Extensibility" for this question, as Custom Analytical Queries are related to Extensibility.

Regards.

Juliano Romanato.

[Maria_cic91]

Hello,I'm experiencing the same issue enabling the hierarchy for a custom field. Could you please share how you addressed this?