Excel spreadsheet in SAS VA

triptiagg200 — Tue, 10 Sep 2019 22:08:12 GMT

Hi,

I am trying to build a dashboard in SAS VA from an excel spreadsheet.

I have imported the sheet in SAS VA, but I am not able to refresh the charts when the new row fields are added in the spreadsheet.

Is it possible to refresh the excel data source?

Re: Excel spreadsheet in SAS VA

Sam_SAS — Wed, 11 Sep 2019 13:11:37 GMT

Hello,

To update the spreadsheet manually, I believe you would just import the spreadsheet again and select "Replace file" in the import window.

I believe it is also possible to set up a scheduled job to do this every day (or every hour, etc) if you have data admin permissions, but this is not an area of expertise for me.

Sam

topic Excel spreadsheet in SAS VA in SAS Visual Analytics

Excel spreadsheet in SAS VA

Re: Excel spreadsheet in SAS VA