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.