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.
Last Modified Date: 15 Dec 2020
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.Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials