SmartView Error "1020011: Maximum number of rows exceeded" When Retrieving Data

SmartView Error "1020011: Maximum number of rows exceeded" When Retrieving Data

Applies to:

Hyperion Essbase - Version: 9.3.1.0.00 to 11.1.2.1.000 - Release: 9.3 to 11.1
Information in this document applies to any platform.

Symptoms

When zooming in on a parent member in SmartView or running a large query with many members, SmartView gives the following error:
"Cannot perform cube view operation. OLAP error (1020011): Maximum number of rows [5000] exceeded".

This error may also appear:

"1042017 Network error: The client or server timed out waiting to receive data using TCP/IP. Check network connections. Increase the NetRetryCount and/or NetDelay values in the essbase.cfg file. Update this file on both client and server. Restart the client and try again"

Cause

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

If you exceed this limit, you will see the error.

Solution

Increase the Max Rows settings by doing the following:

1. Open the \APS\bin\essbase.properties file. (Drive: \Hyperion\products\Essbase\aps\bin\ essbase.properties)
2. Locate the setting:
    service.olap.dataQuery.grid.maxRows=5000.
3. Increase the setting. Please bear in mind the Excel limits 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).

 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
     %HYPERION_HOME%\AnalyticProviderServices\bin directory

§         Location for version 11
     %HYPERION_HOME%\products\Essbase\aps\bin\

Note:Check These Below Things Also and set these things also

1.Right click Essbase server select Edit->Properties->Environment

2.Check Essbase properties (Essbase.cfg file) add the parameter 

          SSPROCROWLIMIT 500000
Note: Max Limit is 500000

3.Restart Essbase services