SAC drill down or Hierarchies function for product dimesion LIVE connection

[Meenal12]

Hello,

I have one question, how can we use CDS Hierarchies for example to drill down on Dimensions? for example how to create level based  like  Region-Country-City drildown or like ( Year>Quarter>Month) 'Level based Hierarchy ?

I want to craete level based Hierarchies for  The field Product Hierarchy (MARA-PRDHA). I am working on LIVE connection. 

Any support would be appreciated.

I saw few articles, buit did not found the excat solution

I am attaching few links below for your reference, 

Hierarchies in CDS views - SAP Community

https://community.sap.com/t5/technology-blogs-by-members/abap-cds-recursive-association-using-hierar...

https://help.sap.com/doc/abapdocu_cp_index_htm/CLOUD/en-US/ABENCDS_F1_DEFINE_HIERARCHY.html

https://community.sap.com/t5/technology-blogs-by-sap/beginners-guide-for-cds-hierarchies-part-2/ba-p...

SAC output should have drilldown on dimensions like below to represent each category or level separately and user should have choice to see level. Similarly like we have for Date (to see it on year month day)