You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SSPROCROWLIMIT

Received Response
13
Views
1
Comments
edited Aug 2, 2018 2:36AM in Essbase 1 comment

Summary

SSPROCROWLIMIT

Content

Has anyone ever used more than 500,000 default value for this settings?

If yes then how much?

Currently i see i will have to use at least 12mil rows for smartview to process which is 24x then the default value but end result after suppressing missing and zeros will be 30k records.

I am just worried if I change that it should not break something else. In the doc, it says to prevent excessive memory usage we are using this settings. I have one question if anyone knows, Is the memory released after the grid operation?

thank you for sharing your experience.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!