KNOWLEDGE BASE

Unable to Select or Find a BEx Query in Step 5 of the SAP NetWeaver Business Warehouse Connection Dialog Box


Published: 14 Oct 2016
Last Modified Date: 30 Nov 2019

Issue

When trying to connect to SAP BW, after selecting a Catalog or InfoProvider, you may be unable to select or find a BEx Query that exists in the database.

Environment

  • Tableau Desktop
  • SAP NetWeaver Business Warehouse

Resolution

Ensure that the BEx Query has the check box “Allow External Access to this Query” selected in the Properties tab of the Query Designer.

Cause

To access BEx queries from Tableau (which is a non-SAP tool) the “Allow External Access to this Query” option must be enabled.
Did this article resolve the issue?