BookmarkSubscribeRSS Feed
Akash93
Fluorite | Level 6

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

6 REPLIES 6
Akash93
Fluorite | Level 6

Hi Team,

 

Please find attached for warning.

 

Regards,

Akash

Madelyn_SAS
SAS Super FREQ

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. 

Akash93
Fluorite | Level 6
Hi

We row limit is already set to 40k and our total data is 29k only.

Regards,
Akash
Madelyn_SAS
SAS Super FREQ

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. 

 

  1. Open the report and select the list table. 
  2. Press CTRL+ALT+Q to open the query diagnostics window. 
  3. Next to the drop-down list with the name of the list table is a > icon. Click that icon to run the query just for that table. 
  4. When it is finished, more tabs will display in the window. 
  5. On the o Results tab, look at the bottom for the section that starts <DataFile>.
  6. There are two values to look at here: rowCount and availableRowCountrowCount is how many rows the table is displaying. availableRowCount is the number of rows actually returned. In this case, the availableRowCount is likely higher than the rowCount
  7. Next, look at the Server tab. 
  8. Scroll to the bottom where you will see propery names and their values. One of the values should match the rowCount you see on the oResults tab. This is the property that would have to be increased in order to display all available rows and avoid the warning. 

 

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. 

Akash93
Fluorite | Level 6
Hi Madelyn,

We are getting desired details by following suggested steps till point # 6.

We are unable to get details for below points :

7. Next, look at the Server tab.
8. Scroll to the bottom where you will see propery names and their values. One of the values should match the rowCount you see on the oResults tab.
This is the property that would have to be increased in order to display all available rows and avoid the warning.

Our Current SAS VA version is : 7.51

Regards,
Akash
Madelyn_SAS
SAS Super FREQ

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. 

SAS Innovate 2025: Call for Content

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!

Submit your idea!

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
  • 6 replies
  • 1533 views
  • 2 likes
  • 2 in conversation