topic VA 7.2 how to get a timestamp of last refresh (dataset) into your report in SAS Visual Analytics

VA 7.2 how to get a timestamp of last refresh (dataset) into your report

EWS — Tue, 18 Aug 2015 08:50:37 GMT

Hello,

I was wondering if there is anyway to get the timestamp of a dataset into a report.

Re: VA 7.2 how to get a timestamp of last refresh (dataset) into your report

skillman — Tue, 18 Aug 2015 12:36:38 GMT

In my environment the LASR load pulls the most recent data from views in Oracle with a predefined prefix. In those views I have a column titled "Refresh Date" and the value is sysdate. When the views are queried the "Refresh Date" column automatically gets the value of the current timestamp in Oracle. This works great for us and any user can look at the "Refresh Date" column in VA to see when the data was last updated.

-shawn

Re: VA 7.2 how to get a timestamp of last refresh (dataset) into your report

EWS — Tue, 18 Aug 2015 14:10:05 GMT

Shawn,

Thanks for your quick reply, I will give it a try.

Re: VA 7.2 how to get a timestamp of last refresh (dataset) into your report

BLE — Thu, 25 Aug 2016 14:54:26 GMT

I have been told by SAS VA tech help that LASR tables are static and oracle tables can not be included in an autoload process.

My LASR tables are based on Oracle tables that are updated often (could be every minute).

To get the most current data into my LASR tables, I registered my Oracle tables with SAS Management Console and am creating scheduled queries in SAS VA to get my LASR tables refreshed with current data from my oracle tables.

Your post gives me the impression you have set up a process that allows your LASR tables to pull from current Oracle table data,

"In my environment the LASR load pulls the most recent data from views in Oracle with a predefined prefix"

Are you using a different process than the one I describe above?

If yes I would greatly appreciate your describing that process.

Thanks,

Bonnie