topic Re: Data update in VA possible ? in SAS Visual Analytics

Data update in VA possible ?

MuratDerin — Sun, 27 Dec 2020 11:12:43 GMT

Hi All,

Does data update possible in VA with any feature or function not only present data ?

Re: Data update in VA possible ?

SASKiwi — Sun, 27 Dec 2020 21:27:59 GMT

Your question isn't clear. Please explain what you mean in more detail.

Personally I find complete table reloads are the easiest approach with SAS VA with all of the data preparation done outside of VA in "normal" SAS.

Re: Data update in VA possible ?

MuratDerin — Mon, 28 Dec 2020 17:32:39 GMT

I know , my question is weird but customer asked us they want to update some data which they see in VA . For example there is a table which is shown in VA. Does it possible to change data from current value to new value ?

Re: Data update in VA possible ?

MuratDerin — Mon, 28 Dec 2020 17:39:05 GMT

I know VA is a kind of dashboard tool. As far as i know VA can only show data uploaded in many variation. adding or changing data in original source of table cannot possible right ? Maybe there is a trick solution ?

Re: Data update in VA possible ?

SASKiwi — Mon, 28 Dec 2020 21:22:20 GMT

@MuratDerin - It is important to remember that if the LASR server shuts down you lose all of your SAS VA data. I find the best way of managing this is to keep a "mirror" of the VA data in a SAS library on disk. Once your LASR server is running again it is very easy to reload your data from the mirror library.

Of course you can run SAS programs that will change some of the variables in LASR tables, but then you also need to be able to recreate the same data after a LASR shutdown. This is where keeping a copy of the LASR tables on disk really helps. Also please note that when you add or delete variables in a LASR table you also need to update the SAS metadata definition of the table.

Re: Data update in VA possible ?

MuratDerin — Tue, 29 Dec 2020 14:21:15 GMT

Thanks a lot !