Problems with large SAP BW queries
When you are working with an SAP BW data source,
if your report includes a data set greater than 1,000,000 cells, you
might encounter an XQE error.
XQE-CON-0007 XQE error encountered: XSB-ERR-0022 Execution of MDX failed: XSB-ERR-0038 SAP Error executing BAPI BAPI_MDDATASET_SELECT_DATA: com.cognos.xqe.data.providers.olap.sbwodp.bapi.JBapiSAPException: RFC Error: MDX result contains too many cells (more than 1 million).
To avoid this error, set the Processing property for the query to Limited Local. This option allows the report to process locally.