Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
quriouss
Creator III
Creator III

Connect directly to SAP cube (infocube) rather than Ole DB query?

I can connect to queries built on my SAP BW cubes just fine;

SELECT (Measures ... ON COLUMNS);

               Dimensions ... ON ROWS

FROM [ACCOUNT_INFO_PROVIDER/QUERY_NAME];

But how can I connect directly to the whole cube (or InfoProvider in SAP's parlance)?  What is the syntax?

I've tried;

  • FROM [ACCOUNT_INFO_PROVIDER];
  • FROM [ACCOUNT_INFO_PROVIDER/];
  • FROM [$INFOPROVIDER];
  • FROM [ACCOUNT_INFO_PROVIDER/$INFOPROVIDER];
  • FROM [$INFOPROVIDER/ACCOUNT_INFO_PROVIDER];

But they all give the same error ("The requested query does not exist on the current server").  I've read the connector manaul for QliKView but although it mentions cube access it only has examples for query access.

(Also: note I am talking about using the connectivity provided with the QlikSense desktop install - I am using a standard SAP BW connector - mdrmsap - not a third party one).

1 Reply
quriouss
Creator III
Creator III
Author

The solution is to prefix the infocube name with '$';

SELECT    Some_Data ON COLUMNS ,

                  Some_Other_Data ON ROWS

FROM [$ACCOUNT_INFO_PROVIDER] ;


(Solution found here; Mapping Metadata - Additional Development Technologies - SAP Library )