Hi Team, Is there option to hide warning shown in attached from VA objects. We are able see all data (maximum rows is 30 k & 29 columns).However, We are getting in viewer. Is there option to remove such warning. Regards, Akash
Hi Team,
Please find attached for warning.
Regards,
Akash
The warning means that there are more rows to display. Even one extra row would cause that message. On the Options tab, try increasing the value in the Override system data limit option.
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
To see how many rows that are actually being returned, you can do this:
Note: I do not recommend posting any query results to the community.
More information about cardinality can be found here: https://support.sas.com/kb/62/148.html . If you have trouble with the query diagnsotics, then let us know what version you are using.
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
Unfortunately, the query diagnostics in 7.51 do not work as well as the diagnostics in Visual Analytics on SAS Viya.
But the most likely limit that is being exceeded is viewerservices.default.max.cells.produced on Transport Services. This property is mentioned in Reference for Selected Properties for All Transport Services Clients
The default is 250,000. Typically, that value is sufficient. You can try increasing this to 400,000 and see if it allows all rows to display. You do this in SAS Management Console. The documentation above has the steps to change a limit on transport services. Note that increasing limits can cause the system to become unstable. You will need to reduce the limit if that occurs.
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.