Skip to Content

Dynamic Join in Calculation View

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.

Add comment
10|10000 characters needed 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?

  • Get RSS Feed

1 Answer

  • Dec 22, 2016 at 03:33 PM

    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/

    Add comment
    10|10000 characters needed characters exceeded