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

Published: 14 Dec 2020
Last Modified Date: 08 Jul 2022


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.


  • Tableau Desktop
  • SAP HANA Calculation View


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)


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?