Restricting data based on nodes of Hierarchy with directory

[Rakesh_]

Hello SAP Community,

We recently encountered a need to create calculated measures based on hierarchy nodes.

For instance, I would like to create a calculated measure for Promotional Incentives withing Total Revenue, specifically focusing on restricting the data related to Promotional Incentives. I would appreciate any thoughts or suggestions on how to accomplish this.

 Thank you in advance for your help!

SAP Datasphere 

[Martin_Kuma]

Hi Rakesh,

I am using restriction from - to on the hierarchy leaves/children. The reason is, that you do not have the values on the booked on the hierarchy nodes, so you have to first create the restricted measure, which you can then use in calculations. Restricted can be created as new lines in the model view (with union), in case you run into performance issues. Else just stick with the measures in the model. 

You can create the measures in the story as well, but I find model approach more re-usable. 

Cheers,

Martin