Skip to Content

CalculationView without aggregation

We are working a lot of with the CalcViews, but one thing we do not get… SAP told us following points:

.

  1. Performance case: we should use CalcViews instead of raw SQL queries on HANA like “SELECT CardCode, CardName FROM OINV” to get a better performance
  2. Deployment SQL data with ServiceLayer: we should use CalcViews to deploy them with odata in common SL way…
  3. We should always use CalcViews, the other types are not necessary anymore (SAP Workshop Waldorf)

.

Now the question: The CalcView always wants a aggregation. But you see on my statement sample that we have only data output in strings...

.

What is your recommendation here? How can we output a CalcView without aggregation here?

.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 25 at 02:14 PM

    There are 2 types of calculation views. Cube and Dimension.

    The second replaced the old and deprecated Attribute Views. They act as table projections and don't require any aggregation.

    This video shows one example. (it's using HANA 2.0, but it's also applied to version 1.0)


    Here is a Calc View of OCRD, with no Aggregation

    and its query result

    Add comment
    10|10000 characters needed characters exceeded