how to get tfswarehouse next refresh time?

Question

Is there any way that i can include Tfswarehouse next refresh time in reports? we are using tfs 2008 sp1.

Thanks,
Ravi Bavanari

Answer 1

never mind, i figured out that we can do it by incrementing lastprocessedtime as below

=DATEADD(

"h",1,CDATE(First(Fields!LastProcessedTime.Value, "dsLastProcessTime")).ToLocalTime())

Thanks.

Answer 2

Yes, the warehouse will update every one hour by default.

Best Regards,
Ruiz

---

Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Sincerely, Ruiz Yi