Last Modified Date: 19 Oct 2019
- Tableau Desktop
- SAP HANA
ResolutionUse the Row.Count column instead of [Number of Records].
The Row.Count column is only available for some HANA Views, for example, if you have created a Calculated Column in the Cube (aggregation node at the top Semantic layer), you will be able to see the Row.Count column in Tableau Desktop after connecting to the Cube.
CauseSome live connections in SAP HANA run on OLAP engine whereas extract connections to SAP HANA do not. The result set for an these views may differ, so [Number of Records] can show a different result depending on which connection is used.
- Number of Records is generated by Tableau and is always 1 for each row in the result set
- Row.Count is a SAP feature, is generated by HANA, and represents the number of rows in the underlying data that match the given combination of dimension values - essentially a count(*) when grouped by all of the dimensions in the query.
Discuss this article...
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials