Timelag on EA

The Time-lag (or Backlog) is one of the KPIs of Europa Analytics (EA). It is defined here as the difference between the date of today and the date of latest loaded data.

This Time-lag is due to the time needed to collect, load and process the data (ETL) procedure currently applied on the EA.

Goals

 * Goal since 2010
 * The goal is to reach the time-lag of maximum 48 hours.
 * The goal has been practically reached after the migration to the new version of the EA with improved ETL.


 * Goal for future
 * The goal is to reach the time-lag of maximum 24 hours.
 * The procedure to collect the data by DIGIT will have to be substantially changed (with subsequent changes in the EA ETL).

Current Time-Lag
Via the report Available Data current time-lag could be found by checking the value of the Latest Date (= read latest date for which the data has been loaded).

The 'Time-lag'='Today' - 'Latest Date'; and should be not higher than 2 days.

Comparing to the previous version (marked as SAS WH) the time-lag has been significantly reduced. (Exception in July 2010, when system has stopped due to problems with installation of a corrective patch.)

The expansion of the Timelag in the period January - May 2011 was due to the incident in DataCenter and then by needed fixes.



Variations of the Time-Lag

 * 1) The Latest Date has to be taken with a lot of caution. It happens that not all log files are delivered in time and they come the day after. It may be even several % of the data which delivered later. There for it is better to take a day before the Last Date if 100% accuracy is needed.