Skip to Content
avatar image
Former Member

Expose a calculation view as a oData service on Hana XSA.


This is my scenario:

I have an calculation view with a result of 3 values.

I expose this calculation view as a oData service.

On data access the result is not the expected result.

This happens when I use stack-views. In this example, the exposed view is created by a join between two others calculation views.

! On oData result, only the first value from view is repeated. In this example the first row is repeated for 4 times but only 1 time is expected.

Where can be the problem?

Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 26, 2017 at 05:22 PM

    I am not able to infer a lot from the screen shot, but can you check if you are using a prjection or aggregation node in your calc. view. Also the join may be a cross-joins, and not be on an unique field and produces.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I use a projection node in the calculation view. The calculation result(not in oData service) - gives the right result. So, the join shouldn't be the problem, in my point of view.

  • Apr 27, 2017 at 02:39 AM

    The URL you use to access the OData service shows that you request the record count ($count) and not the actual values.

    The result (3) is the correct, given your example screenshot.

    You may want to adjust the URL to your expected result.

    Add comment
    10|10000 characters needed characters exceeded

    • Ok, let's try the other way around: how can this be reproduced? Show us to create this behaviour and maybe somebody is willing to reproduce and analyse this for you. I'm certainly not interested in dealing with your defensive argumentation.

      After all, you got the issue and seek help, isn't it? So, you should be interested in helping the folks who could help you.