“Cannot perform cube view operation. OLAP error (1020011): Maximum number of rows  exceeded.”
To increase the maximum number of rows a user can retrieve, or submit, edit the service.olap.dataQuery.grid.maxRows property in the essbase.properties file. The default is 5000. While editing this property, it may be benefitial to evaluate the size if the columns (.olap.dataQuery.grid.maxColumns), which is set to 255 by default.
Once this is updated, restart the Hyperion services.
The location of the essbase.properties file is dependent on the version of Essbase installed. Start by going to the server with APS installed.
Location for version 9.3
Location for version 11