SAP Knowledge Base Article - Preview

1298510 - Export to Excel error: 'Your query [Document Name] contains [######] cells, which exceeds the pre-defined limit of [100000]' in Analysis Edition for OLAP/Voyager

Symptom

  • Exporting an OLAP Workspace or Analysis Edition for OLAP to Excel gives an error: << Your query [Document Name] contains [######] cells, which exceeds the pre-defined limit of [100000]. Please decrease your query size or ask your administrator to increase the cell limit. >>


Read more...

Environment

  • Business Objects XI R2
  • Business Objects XI 3.0
  • Business Objects XI 3.1
  • SAP BusinessObjects Business Intelligence Platform BI4.0
  • Analysis Edition for Olap 4.x

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2 ; SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI 3.0 ; SAP BusinessObjects Enterprise XI 3.1

Keywords

r3.1, r3, r2, drill thru, Business Intelligence, AOLAP, OLAP, Advanced Analysis for OLAP, Voyager, BI, 4.0, 40, BI4.0, BI40, 4.1, 41, BI4.1, BI41, 4.2, 42, BI4.2, BI42, XIR3.1, XIR31, 3.1, 31, MDAS, multidimensional analysis services, workspace, work space, MDAS, multidimensional analysis services, mdas.properties, multidimensional.services.export.cells.limit=100000 , KBA , BI-RA-MD , OLAP Intelligence, multidimensional databases , BI-RA-AWB , Analysis, edition for OLAP (Web) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.