Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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).
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 )