Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

quriouss
Contributor 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
Contributor III

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

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 )

Community Browser