Many times we face this issue while connecting to Smartview and we get error maximum number of row exceeded. The reason being
SSPROCROWLIMIT is not working correctly in Essbase Server 18.104.22.168.000
In Essbase 22.214.171.124.000, this setting does not work for values > 500,000.
Essbase always returns the error “Maximum number of rows processed  exceeded [……]”.
If the value of SSPROCROWLIMIT is > 500000, Essbase seems to go back to the default of 250000.
The documentation for 126.96.36.199 says that SSPROCROWLIMIT still can be set to > 500000, although it is discouraged for performance reasons.
The issue has been addressed in Essbase 11.1..24.004 PSU as can be seen in Patch Readme:
FIXED DEFECT LIST OF ESSBASE 188.8.131.52.004PSU
21764969 MERGE PATCH FOR BUG 21556292
Action Plan :
- Apply Essbase Server Patch 184.108.40.206.004 PSU or higher to fix this issue.
Find the latest available patch set for Essbase via KM Doc ID 1396084.1