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?
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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.