Connect to SAP BW Infocube using XMLA - unable to read data from some queries
===

Using a XMLA connection, our java application connects successfully to SAP BW Infocube and we are able to see all the queries. 

However, we are unable to read data from some of the SAP BW Infocube queries. Using BEx (via Excel) we are able to read data from these same queries.

Is there a setting in the Infocube Query Designer that needs to be changed to enable us read the data from these queries via XMLA?

Are there specific requirements for setting up Infocube queries to enable data extraction via XMLA connections?


Any assistance appreciated.