在即時 SAP HANA 檢視中使用維度/FIXED LOD 同時進行篩選時導致錯誤「Abstract Query SELECT [$temp4_<field>] is not defined」

問題

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"

環境

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

解決方法

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:

Open a new Calculated field and type the following:
[field] + ""
Press OK.
Drag this field to the view.
Drag the original field to filters.
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.