KNOWLEDGE BASE

Incorrect Values Based On Level Of Detail When Connecting To A Sap Hana Calculation View


Published: 14 Dec 2020
Last Modified Date: 15 Dec 2020

Issue

In Tableau Desktop, when the view has the most granular level of detail available in the data source, the results are correct. However, if the results are aggregated at a lower level of detail, the aggregated results are incorrect.

Environment

  • Tableau Desktop
  • SAP HANA Calculation View

Resolution

In SAP Hana Calculation View, ensure that 'Keep Flag' is enabled for the field which provides the granularity needed.
More information is available on SAP blog post: Usage of “Keep Flag”(external)

Cause

The keep flag will force a fine granular aggregation even in situations in which it might not be required. 
Did this article resolve the issue?