/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
The HANA calculation view is defined as a dimension view like the following:
The column values change when running select on different columns from the calculation view:
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)