SAP Knowledge Base Article - Preview

2551133 - Data being aggregated instead of being projected in the calculation view

Symptom

The HANA calculation view is defined as a dimension view like the following:

3.PNG

The column values change when running select on different columns from the calculation view:

7.png

8.png

The query doesn't have any aggregations applied, however the value for column "SEATSOCC" got automatically aggregated. Expected behavior is to have the original column values, no matter which columns were selected for output.


Read more...

Environment

  • Hana 1.0
  • Hana 2.0

Product

SAP HANA 1.0, platform edition

Keywords

keep flag, calculation view, Aggregation node, projection node, incorrect query result , KBA , HAN-DB , SAP HANA Database , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.