Change Time for Daily Update of Data Warehouse
Would it be possible to change the time when the data warehouse does its daily update? I have been informed that this is updated at 2am every night (in phases). For some of the daily metrics, it would be more beneficial if this data was updated closer to 5-6am for the daily operations meeting to capture any work orders that occurred during 3rd shift prior to that operations meeting.
Thanks,
Josh Boswell
1
vote
Joshua Boswell
shared this idea
The reason that the data warehouse is updated at this time is because it takes several hours for all the data to be refreshed. Doing it overnight has the least effect on users of the system.