Is it possible to create hierarchy variables in Datasphere/Analytical Model?

[BW1]

Dear all,

May I ask you if you have found a possibility to create variables containing hierarchies in SAP Datasphere? 
Users need to be able to select hierarchy nodes in SAC prompts - Otherwise they have to select hundreds of single values.

Thank you
Timo

[michal_majer]

Hey,

You can do it by example by defining hierarchy in the dimension first:

Using dimension in the Analytical Model will give You option to render data in hierarchy + filter based on that.

Usefully links:

https://developers.sap.com/group.data-warehouse-cloud-hierarchies.html

https://www.reyemsaibot.com/2024/02/28/sap-datasphere-hierarchies-like-in-sap-bw/ 

[BW1]

Thank you Michael.
But do you maybe know any possibility to show this hiearchy in the prompt that comes up when the dashboard opens up?