KNOWLEDGE BASE

Number of Records Shows Incorrect Results With SAP HANA


Published: 20 Jul 2017
Last Modified Date: 21 Jul 2017

Issue

When using SAP HANA, "Number of Records" might show incorrect results in Tableau Desktop.

Environment

  • Tableau Desktop 10.3.1
  • Windows
  • SAP HANA on BW

Resolution

Use pass-through functions to replicate the correct function in the database. For example: 
rawsqlagg_int("count(*)") 

For more information about such functions, see Pass-Through Functions in Tableau Help.

Cause

Tableau generates the counts as: SUM(CAST(1 AS BIGINT)). This generates the incorrect result and HANA calculation view requires "Count(*)".
Did this article resolve the issue?