Skip to Content
0

Dynamic Join in Calculation View

Dec 21, 2016 at 02:57 PM

72

avatar image

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.

10 |10000 characters needed characters left characters exceeded

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?

2
* Please Login or Register to Answer, Follow or Comment.

1 Answer

SeethaRamaiah Bharani Dec 22, 2016 at 03:33 PM
0

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/


vahtn.png (19.0 kB)
8fy5u.png (21.2 kB)
Share
10 |10000 characters needed characters left characters exceeded