Where in the Data Warehouse is the timestamp for the last Data Collection or Data Movement job?
One of our customers is requesting to include in the footer of the report the timestamp of when the DataMovement job was last run to update the data warehouse and have this display next to the timestamp for when the report was run.
I found in one of the RI templates where you add a singleton into the footer to have the RRDI or Insight report include the last snapshot date, but I'm not sure what field to drag into the singleton to display the date and/or time.
Is this value stored in the data model somewhere or is there another way to do this?
I found in one of the RI templates where you add a singleton into the footer to have the RRDI or Insight report include the last snapshot date, but I'm not sure what field to drag into the singleton to display the date and/or time.
Is this value stored in the data model somewhere or is there another way to do this?
Accepted answer
Hi Michael,
The data for last ETL time is stored in the ETL_INFO table in the data warehouse. Check out the 'ETL Statistics' data model for information on what data is available. I believe this information was introduced starting with Insight 1.1
I'm not sure if you can merge this data in with any of your existing reports, but at least it's a place to start looking. Hope this helps!
The data for last ETL time is stored in the ETL_INFO table in the data warehouse. Check out the 'ETL Statistics' data model for information on what data is available. I believe this information was introduced starting with Insight 1.1
I'm not sure if you can merge this data in with any of your existing reports, but at least it's a place to start looking. Hope this helps!