I get a TON of support calls on how to increase the rows in Smart View. I decided to just document it for one of our clients, and if course I HAVE to share it with you! 🙂
Right click on the server in EAS and select Edit->Properties
Click on the Environment Tab:
Use the scroll bar on the right to scroll down.
Type: SSPROCROWLIMIT 300000
Click on Apply and the restart the Essbase Services for it to take effect.
https://docs.oracle.com/cd/E12032_01/doc/epm.921/html_techref/config/ssprocrowlimit.htm
Happy drilling!!!!
~Sum
EPMSxSW 