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
But how can I connect directly to the whole cube (or InfoProvider in SAP's parlance)? What is the syntax?
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).