how to increase the default setting of displaying 40,000 rows in SAS Visual Analytics 9.4 M7?

[ashasupriya]

Folks - Please help me know how to increase the default setting of displaying 40,000 rows in SAS Visual Analytics 9.4 M7?

Regards,

Asha

[Madelyn_SAS]

If you are encountering a client-side limit (as opposed to a server-side limit), you should be able to adjust the limit on the object itself in Visual Analytics Designer. On the Options tab for the object, select Object > Override system data limit. This change impacts only that specific object. 

[ashasupriya]

@Madelyn_SAS - Thank you for your response. However, I tried that and it will return the query too big error message.

[SASKiwi]

@ashasupriya  - This sounds like an issue for SAS Tech Support.

[Dee2]

I found out the error is from a calculate item that was used in the table list. I fixed the item and the error is gone. Thanks.

[Dee2]

Sorry I posted in the wrong place but can't delete it.