Analysis for OLAP Pre-define limit

Hi All

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

Thanks
Murali


mmuralimano (BOB member since 2011-11-21)

Hi

Not really a webi-question, but here’s an answer anyway :slight_smile:

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.

Good luck

/Björn


Bjorn :sweden: (BOB member since 2006-02-10)

Hi Bjorn

Thanks for your prompt reply.

I could find out the MDAS configuration, but there is no option is saying about export limit size 10000,

Apart from this I checked all the APS , there is no MDAS configured in our environment.

I have attached the screen shot, Please suggest is other way to find out this.

Thanks
Murali
MDAS.jpg


mmuralimano (BOB member since 2011-11-21)

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.


bension (BOB member since 2005-09-01)