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

[EWS]

Hello,

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

[skillman]

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

[EWS]

Shawn,

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

[BLE]

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