Increase Rows in Smart View

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

Serveredit

Click on the Environment Tab:

environment

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.

setting

https://docs.oracle.com/cd/E12032_01/doc/epm.921/html_techref/config/ssprocrowlimit.htm

Happy drilling!!!!

~Sum

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s