BookmarkSubscribeRSS Feed
barbe1lj
Calcite | Level 5

Hello,

 

Does anyone know how to reset a server limit to allow more than 40,000 rows to show within a disaggregated listbox in SAS Viya VA? We reset the ListBox settings from 40,000 to 2,000,000 and the dataset is still only showing up to 84,000 rows.

After we increased the limit we see the error: Not all of the data appears because the client query row limit exceeds the server threshold.

1 REPLY 1
Madelyn_SAS
SAS Super FREQ

You are likely running into a server-side limit. This note explains the limits:

https://support.sas.com/kb/62/148.html

 

 

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 2142 views
  • 0 likes
  • 2 in conversation