Is there any limit when export it to excel as a Analysis edition for OLAP report.
As user is facing the issue when the report cannot export over 100,000 cells. and got below error message.
“Your Query [Z_Z******] contains [305,520] cells, which exceeds the pre-defined limit of [100,000], please decrease the query size or ask your administrator to increase the cell limit.”
Users asked us to set a pre-defined limit of 500000. Please suggest me Where we can set a pre-defined limit of 500000 cells in Analysis edition for OLA. Please provide any steps
Not really a webi-question, but here’s an answer anyway
This can be changed in CMC Application.
You must find the AdaptiveProcessingServer which includes the MultiDimensionalAnalysisSservice, and change the settings to 500000. If you dont have access to CMC, ask your BO admin to make the changes.
I know this post is a few years old but I ran into a similar issue. Try looking at SAP note 1298510.
It suggests the following update:
Navigate to: \Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\pjs\services\MDAS\resources\com\businessobjects\multidimensional\services\mdas.properties
Increase the limit in the line: multidimensional.services.export.cells.limit=100000
The path might be slightly different depending on your version and if you are using unix.