라이브 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.