One cube in SAP BW accessible by BEx query, but not directly.

Created
October 08, 2021 23:29

Date Posted: 2017-10-23
Product: TIBCO Spotfire®

Problem:

Solution:

When a cube in SAP BW is of type MultiProvider, the user may get the following error when attempting to open it in Spotfire.

===================
2015-05-28 12:57:45,038 [23] DEBUG Spotfire.Dxp.Data.Adapters.SapBw.SapBwMetadata [(null)] -
    SAPBW: ... Loading metadata and creating immutable schema for cube $CUBENAME in catalog $INFOCUBE failed with exception:
    Object or provider is not capable of performing requested operation. (duration: 00:00:02.3279909)
2015-05-28 12:57:45,038 [23] ERROR Spotfire.Dxp.Data.Adapters.SapBw.SapBwMetadata [(null)] -
    Could not access metadata for cube '$CUBENAME' in database '$INFOCUBE'"
    System.Runtime.InteropServices.COMException (0x800A0CB3): Object or provider is not capable of performing requested operation.
====================

The user needs to work with their SAP BW Administrator to provide the additional access/permissions needed for the Spotfire user account to access the cube from Spotfire. http://help.sap.com/saphelp_nw70/helpdata/en/52/1ddc37a3f57a07e10000009b38f889/content.htm