1 Reply Latest reply: Apr 17, 2015 6:00 AM by Simon Hogg RSS

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

    Simon Hogg

      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).