cancel
Showing results for 
Search instead for 
Did you mean: 

Percentage in cross model

Ganjos
Participant
0 Kudos
138

Hi team,

I am working on a project that involves two associated models. One model contains human resources and departments, where I calculated the costs of each department divided by the total department costs (Percentage). It is important to note that the departments are organized in a hierarchy that includes resources (REC1, REC2, REC3, etc.). However, I also have a department dimension that lists the departments, but it is not being used. I should mention that I tried linking the models through this dimension, but it didn’t retrieve the calculated measure with the percentage mentioned earlier.

In the other model, I have general expenses (electricity, rent, etc.), as well as departments with specific costs and specific expenses. What I want to achieve is to multiply the general expenses by the percentage from the human resources model. Is it possible to accomplish this?

Thanks in Advance

Ganjos

View Entire Topic
William_Yu
Product and Topic Expert
Product and Topic Expert
0 Kudos

I assume there might be few options: 

  1. Use cross model copy to copy the percentage from source(human resource) model to target(expense) model, and add a step in the end to delete the copied percentage. Note that, cross model copy can take over calulated measure in the source model. 
  2. Directly calculate percentage from source model by LINK keyword. 
  3. If this tenant is ON HANA Cloud, calculate measure result can be used direct with addtional statement CONFIG.READ_CALCULATED_MEMBER_VALUES  on top
Ganjos
Participant
0 Kudos
Hi @William_Yu, thank you for your response! Is there a way to select multiple members, not just leaf nodes?
William_Yu
Product and Topic Expert
Product and Topic Expert
0 Kudos
it depends on how you create your parameter, if you don't restrict to leaf then you can select parenet as well
Ganjos
Participant
0 Kudos

i created for any but in data action appear this for the parameter:

 

Ganjos_0-1736851045267.png