KNOWLEDGE BASE

Unable to Connect to a MultiProvider or ODS object when connecting to SAP BW


Published: 14 Oct 2016
Last Modified Date: 14 Oct 2016

Issue

When trying to connect to a MultiProvider or ODS object, you are unable to fnd such an object when connecting to SAP BW from Tableau.

Environment

  • Tableau Desktop
  • SAP NetWeaver Business Warehouse

Resolution

To connect to another object such as a MultiProvider or an ODS object:
  1. create a BEx Query on it, and then connect to the BEx Query.
  2. Ensure that the check the box “Allow External Access to this Query” in the Properties tab in the BEx Query Designer application.

Cause

Tableau supports connections to a BEx Query or InfoCube. 
Did this article resolve the issue?