It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×12,010
×7,479
×1,230

question asked: Feb 13 '13, 1:38 a.m.
question was seen: 6,002 times
last updated: Feb 13 '13, 10:38 a.m.

Related questions

Where in the Data Warehouse is the timestamp for the last Data Collection or Data Movement job?

0
Michael Walker (992●15●201●157) | asked Feb 13 '13, 1:38 a.m.
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?

Accepted answer

1
permanent link
Jackie Albert (1.6k●1●49●47) | answered Feb 13 '13, 10:38 a.m.
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!
Michael Walker selected this answer as the correct answer

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.