"OLAP_error(1020051): Maximum number of rows processed[250000] exceeded[394321]"

This is on Essbase version 11.1.1.3

By default the Max Rows setting for Analytic Provider Services is set to 5000.

If we exceed this limit, will get the below error
"OLAP_error(1020051): Maximum number of rows processed[250000] exceeded[394321]"

So increase the Max Rows settings by doing the following: 

1. Open the \APS\bin\essbase.properties file. 
2. Locate the setting: 
service.olap.dataQuery.grid.maxRows=5000. (we can set service.olap.dataQuery.grid.maxRows=0(no limit))
3. Increase the setting. Microsoft Excel has limits as specified below. 
4. Save the file and restart the Analytic Provider Services server. 

For Excel 2003, there is a limit of 65535 rows. 
For Excel 2007 with version 11.x of SmartView the limit is 1,048,576 rows (but this is dependent on system memory).