SAP OLAP Universe --> Limit Size of result set

Hi Experts,

Pls inform, the SAP recommendation for this option in OLAP Universe.

Parameters --> Controls Tab:

Limit Size of reult set.

By Default it is set to 5000 rows. Is it SAP recommendation is to set to 5000 rows and not more than that.

Q: Do we need to uncheck option? Impact : Is BW backedn has huge records say: 100, 000 rows, then all the records will come to Webi report which will make the report crash, thoughts?

Regards,

AK