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
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.
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.
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.
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.