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

[BW1]

In case you want to support this I just found a related improvement request:

Improvement Request Details - Customer Influence

[Martin_Kuma]

Hi, yes, you cannot use hierarchies in model-variable.

Only as input-control or story filter. There you can add hierarchy, but not in model-variable. 

The hierarchy is model is missing. Same issue for restricted measures with hierarchy. 

Martin

[BW1]

Thank you Michael.
I hope SAP will add it to the roadmap as I cannot find it.

[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?