topic Re: Freezing data explorations in SAS Visual Analytics

Freezing data explorations

Josh_Breault — Tue, 17 Apr 2018 20:00:22 GMT

Hello. Myself and my company are new SAS users and I was hoping someone could give me some insight. In our database we are currently doing weekly refreshes of our data. It is my understanding that if someone is in an exploration say on Wednesday, when the data refreshes over the weekend, the content of the exploration will update when it is opened on Monday.

If someone wanted to, could they 'freeze' the data in an exploration so that it doesn't refresh, even if the data source is refreshed?

Any advice would be appreciated.

Thanks.

Re: Freezing data explorations

SuryaKiran — Tue, 17 Apr 2018 20:12:03 GMT

How is your data loaded into LASR server. Is it scheduled to refresh after the source data is updated?

Re: Freezing data explorations

SASKiwi — Wed, 18 Apr 2018 03:02:42 GMT

A saved Data Exploration is simply a description of how you want to analyse a LASR data table and doesn't include the data itself. If the LASR data table is refreshed then the next time you run your Data Exploration it will use the updated data.

If you have a need to keep historical data as well as current data so you can reproduce 'old' explorations, then your LASR table refresh needs to be changed so it keeps history while adding new data.

Re: Freezing data explorations

Josh_Breault — Wed, 18 Apr 2018 11:19:51 GMT

Thank you for your response. That is what I thought but I just wanted to confirm so I could answer the question appropriately.

Re: Freezing data explorations

Josh_Breault — Wed, 18 Apr 2018 11:37:18 GMT

It is manually loaded on sunday mornings by our IT admin at this point, but he is still working on figuring out how to set a weekly schedule to have it refreshed and uploaded.

We just didn't know, if someone opened an exploration a few weeks after they started it, would they have to push a button to refresh or would it do it automatically since the data source has since been refreshed and uploaded. I believe we got our answer from another post, but anything additional you could add would be helpful.

Thanks.