CalculationView without aggregation

[Simon_nAG]

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?

.

[former_member197733 · Accepted solution]

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

[Simon_nAG · Accepted solution]

Is there also a possiblity with the calculation type generated by SQL?

[former_member197733 · Accepted solution]

I don't think so. The whole concept of using views instead of raw queries is that you won't do the queries on your own. I.e. Not using scripting view 🙂