Loading

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

Udgivelsesdato: Mar 28, 2025
Beskrivelse

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

Cause

Some live connections in SAP HANA run on an OLAP engine whereas extract connections to SAP HANA do not. The result set for these views may differ, so the [Number of Records] field can show a different result depending on which connection is used.

Løsning
Use 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.
Yderligere ressourcer
  • 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.


Vidensartikelnummer

001473111

 
Indlæser
Salesforce Help | Article