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: 14 Oct 2016

Issue

When trying to connect to SAP BW, after selecting InfoProvider from Step 4 of the SAP NetWeaver Business Warehouse Connection dialog box, you are unable to select or find a BEx Query in Step 5.

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.

Additionally, also verify that the Query does not have a mandatory variable defined in it.

Cause

Tableau does not support Queries with mandatory variables. You can also refer to this forum post on the Simba website to help resolve your issue.
Did this article resolve the issue?