topic Re: SAS VA Designer: Only some of data appears because there is too much data to display in SAS Visual Analytics

SAS VA Designer: Only some of data appears because there is too much data to display

raju_10_thota_gmail_com — Thu, 25 Jan 2018 13:49:40 GMT

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

Re: SAS VA Designer: Only some of data appears because there is too much data to display

Madelyn_SAS — Thu, 25 Jan 2018 14:36:32 GMT

How many data items are assigned to the list table?

Re: SAS VA Designer: Only some of data appears because there is too much data to display

raju_10_thota_gmail_com — Thu, 25 Jan 2018 14:42:25 GMT

Hi,

Thank you for your replay.

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

Re: SAS VA Designer: Only some of data appears because there is too much data to display

raju_10_thota_gmail_com — Fri, 02 Feb 2018 12:45:22 GMT

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

Re: SAS VA Designer: Only some of data appears because there is too much data to display

Madelyn_SAS — Fri, 02 Feb 2018 16:29:31 GMT

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#p1bvyovhxe6bw7n16xs30eg6ch71.htm

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