Essbase Error (1020011): Maximun number of rows [5000] exceeded.

Some days ago a client called with a problem in smartview.
He was making a large sheet but when retrieving he was getting a error:

The solution was ‘simple’:
In the APS  (Provider Services) there is a file that limits the maximum records that can be retrieved.

You can edit the file ‘essbase.properties’ to remove the limit.
To find the file , you can just go to the webpage of your installation:
http://localhost:9000/aps/APS (in weblogic)
http://localhost:19000/aps/APS (in OHS)

Edit the file ‘D:\Oracle\Middleware\EPMSystem11R1/common/EssbaseJavaAPI/11.1.2.0/bin/essbase.properties' so that smatview can retrieve more than 5000 records.

Go to the following line: ‘service.olap.dataQuery.grid.maxRows’
# Specifies maximum rows/columns for dataquery grid. 0 value indicates no limit.
#service.olap.dataQuery.grid.maxRows=5000
service.olap.dataQuery.grid.maxRows=0
service.olap.dataQuery.grid.maxColumns=255

Keep in mind that Excel has a limit in record that can be handled:
Excel 2003: 65536
Excel 2010: 1048576


Restart the APS and your done.