BookmarkSubscribeRSS Feed
raju_10_thota_gmail_com
Calcite | Level 5

Hi,

 

I need advise on this warning message. This issue is occurred in list table and summarised records are 802 shown in totals of table. There is a warning yellow triangle to indicate message. List table only display  707 instead out of 802 with warning message. VA user guide indicate around 40,000 records can be rendered in list tables.

 

There are filter on list table which bring down records to 802 records.

 

I am bit confused and thinning might have some option which would allow to display all data.

 

Please help with this issue to display all data. I have not seen any options which enable all data display but I am guesting there might be some solution for this issue.

 

Thank you for help

 

 

4 REPLIES 4
raju_10_thota_gmail_com
Calcite | Level 5

Hi,

 

Thank you for your replay.

 

19 data items are assigned to the list table (14 character & 5 measures).

 

raju_10_thota_gmail_com
Calcite | Level 5

Data explorer can list these data items without any warnings, I am assuming that some kind of data/memory limitation for report designer. any one in community facing similar issue? are there any approach to mitigate these sort of errors?

 

is it right in saying that report designer is not capable as data explorer ? or it just how these app's has been configured in platform

Madelyn_SAS
SAS Super FREQ

Is it possible that an administrator has reduced the limit for list tables in Visual Analytics Designer to something like 15,000?

 

Note that the explorer can display a maximum of 100,000 rows. See

 

http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#p1bvyovhxe6bw7n16xs30...

 

 Additional question: Are there any filters interacting with the table? This SAS note is for SAS Mobile BI but it contains a way to calculate the number of cells. Your hard maximum limit for Designer is 40,000.

 

http://support.sas.com/kb/58/303.html

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 4 replies
  • 982 views
  • 0 likes
  • 2 in conversation