topic Re: Report Performance in SAS Visual Analytics

Report Performance

KarunaTiwari — Fri, 04 May 2018 10:35:17 GMT

Hi all,

I am creating similar kinds (not same) of Reports for 5 different Geographies.

What will be better in terms of Report Performance- Creating One table in EG for all the Geos and filtering the data in Reports or Creating 5 different tables and using them in 5 Reports??

PS - The data is huge for all the Geos and the Reports are taking considerable amount of time in Opening.

Thanks in advance,

Karuna Tiwari

Re: Report Performance

Erik_Zencos — Fri, 04 May 2018 17:31:07 GMT

Hi Karuna, you should do some testing first. If you create one big table in EG, and use a datasourcefilter in VA on the LASR table, and it takes more than ca 7 seconds to open a report (more than that, and the report users are going to be annoyed) you should create 5 smaller LASR tables.

I don't remember the source, but reasearh found about 7 seconds to be max for opening a report before users have a negative experience, so I always try to have that as my limit. The alternative then is to add more hardware.