06-18-2018 09:26 PM
Let's say I have this scenario where I have created a dashboard in VA using the data source from excel (say: product sales for period 1). Is it possible to create a way where the system can automatically update the spreadsheet data in the lasr and update the va dashboard each week when I receive the new report?
06-18-2018 09:42 PM
Yes. The best way in my opinion is to schedule a SAS batch job, which you can do in Management Console, which reads the excel file at the appropriate time then updates the LASR table. I'd also recommend using a SAS data library on disk to stage the data prior to loading into LASR, and if the table isn't large do any updates in the staging library first and then do a complete table replace in LASR.