KNOWLEDGE BASE

Number of Records Returns Different Values Between Live and Extract Connection to SAP HANA


Published: 29 Jan 2016
Last Modified Date: 06 Sep 2017

Issue

The field Number of Records returns different results when using an extract than when using a live connection.

Environment

  • Tableau Desktop
  • SAP HANA

Resolution

Use Row.Count instead of Number of Records.

Cause

Live connections to SAP HANA use an Analytic View, whereas extract connections to SAP HANA do not. 

Additional Information

Number of Records is a calculated field generated by Tableau Desktop. Row.Count is a field generated by SAP HANA for use with analytic views. 
Did this article resolve the issue?