How to use Hierarchy and Drilldown IN SAC - Live Connections

[former_member596364]

Dear Experts,

How to use Hierarchy and Drilldown In SAC using Live connection? I think the I need to user hierarchy in Calculation view, corretct? I found this link https://www.sapanalytics.cloud/resources-taxonomic-hierarchy/ but it just works without working with live connections

[DebjitSingha · Accepted solution]

Hi Bruno,

Please check below links (Videos) on Hierarchy on live connection. Setup of hierarchy in SAC will remains the same-

• SAP Analytics Cloud: Work With Hierarchy & Hierarchy Node Variables (BW Live Data Series Part 4)
• SAP Analytics Cloud: Create Custom Group Hierarchies in Stories (BW Live Data Series Part 7)
• Create level-based hierarchies
• Blitz Unboxing “Custom Hierarchies/Groups for BW Live” in SAP Analytics Cloud
• SAP Analytics Cloud - HANA Live Connection Best Practices (Please check hierarchy section)

Viewers - If you find above information helpful, feel free to up-vote.

Thanks.

[former_member702610 · Accepted solution]

Hi Debjit,

It would be very grateful if you could answer tomy query related to drill down. We are trying to enable drill down in SAC stories using HANA view. Location view is in place having location data based on country. Region and city data is in reporting hana view on which story is based. Could you please let me know if we need to create hierarchy in reporting hana view? If yes, then how geo map will identify hierarchy in SAC. We want drill down on map like Region-Country-City.

Regards,

Shruti

[hpbimmer · Accepted solution]

Hi Debjit, your links are for BW Live connection. How to consume hierarchies from HANA views in HANA Live connection?