Dynamic Join in Calculation View

[P561888]

Hello Experts,

I have tried the Dynamic Join in Calculation View. But it is not working as expected. I took same examples from SDN but still facing value differences.

Below are the followed:

https://blogs.sap.com/2014/01/07/sap-hana-using-dynamic-join-in-calculation-view-graphical/

https://blogs.sap.com/2016/12/17/constant-selection-in-sap-hana-using-dynamic-join/

BR,

Bharani.

[lbreddemann]

You will need to be a lot more specific about your problem.

What exactly did you try? How do your tables, data and models look like?

What results are you expecting and what do you actually get?

[P561888]

Hello Lars,

Thanks for your time.

I have tried same mentioned in the Community Blogs but in my case it was multiplying 4 times.

For Example: Salary and Total Salary

I can able to see the Region with Salary - Correct but if i include the Total Salary in the Value Axis and it was multiple with Distinct Employee types.

https://blogs.sap.com/2014/01/07/sap-hana-using-dynamic-join-in-calculation-view-graphical/

If I insert the Total_Salary , I am getting the value like this which is 4 times multiplied with Salary.

https://blogs.sap.com/2016/12/17/constant-selection-in-sap-hana-using-dynamic-join/