KNOWLEDGE BASE

Using a Dimension/Fixed LOD in a Live SAP HANA View to also Filter Causes the Error "Abstract Query SELECT [$temp4_<field>] is not defined" to Occur


Published: 15 Feb 2019
Last Modified Date: 11 Jun 2019

Issue

Using a Dimension or a Fixed LOD in a live SAP HANA view to also filter the view causes this error to occur:

"Abstract Query SELECT [$temp4_<field>] is not defined"

Environment

  • Tableau Desktop 2018.2.6, 2018.3.3, 2019.1.0
  • Live SAP HANA
  • Native Connector

Resolution

Option 1

Upgrade to Tableau Desktop 2018.3.6 or a newer version. See Tableau Desktop Downloads and Release Notes for downloads of current and previous versions of Tableau Desktop.  For more information on current releases, see Upgrade Tableau Desktop and Desktop Upgrade.

Option 2

In some cases, this error may only appear when trying to filter to greater than 2 values in the view. The below workarounds still apply.

Workaround 1
Use an ODBC connection, instead of the native SAP HANA connector. (Note: Some features may be lost when using this connector.)

Workaround 2

If the field being filtered on is a Dimension, follow the below steps:
  1. Open a new Calculated field and type the following:
  2.  [field] + ""
  3. Press OK.
  4. Drag this field to the view.
  5. Drag the original field to filters.
  6. The error should no longer appear as Tableau now sees the Calculated field and the Original field as two different fields.

Workaround 3

If the field being filtered on is a Fixed LOD, try modifying the calculation to be based on an Include or an Exclude function.

Workaround 4 

Use an Extract instead of a live connection.

Cause

This issue (ID: 876421) has been resolved in a neewer version of Tableau Desktop. 
Did this article resolve the issue?