Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Report Performance

Reply
Contributor
Posts: 37

Report Performance

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

Occasional Contributor
Posts: 16

Re: Report Performance

Posted in reply to KarunaTiwari

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.

 

Regards,

Erik Meyer

Contributor
Posts: 37

Re: Report Performance

Posted in reply to KarunaTiwari
Thanks for your reply Erik!!
Ask a Question
Discussion stats
  • 2 replies
  • 134 views
  • 1 like
  • 2 in conversation