Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

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

Reply
Occasional Contributor EWS
Occasional Contributor
Posts: 19

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

Hello,

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

SAS Employee
Posts: 85

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

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

Occasional Contributor EWS
Occasional Contributor
Posts: 19

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

Shawn,

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

Contributor BLE
Contributor
Posts: 33

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

 

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

 

 

Ask a Question
Discussion stats
  • 3 replies
  • 631 views
  • 3 likes
  • 3 in conversation