TDQ_V_ALL_RUN_OVERVIEW_ANALY
: contains all analysis primary keys with the calendar timeTDQ_V_LAST_OVERVIEW_ANALY_EXEC
: contains the primary key of the last execution of each overview analysis. This views usesTDQ_V_ALL_RUN_OVERVIEW_ANALY
TDQ_V_LAST_RUN_OVERVIEW_ANALY
: contains the primary key of the last execution of each analysis alongside with the time execution information and the foreign keys to calendar and time dimensions. This view usesTDQ_V_ALL_RUN_OVERVIEW_ANALY
andTDQ_V_LAST_OVERVIEW_ANALY_EXEC
Detailed description of views:
TDQ_V_LAST_RUN_OVERVIEW_ANALY
and
TDQ_V_ALL_RUN_OVERVIEW_ANALY
ANALYSIS_PK
: foreign keys to the analysis dimension tableCAL_PK
: foreign keys to the execution date of the analysisTIME_PK
: foreign keys to the execution time of the analysisAN_RUNTIME
: execution date of the analysis
TDQ_V_LAST_OVERVIEW_ANALY_EXEC
ANALYSIS_PK
: foreign keys to the analysis dimension tableLast_RUNTIME
: count of last version of the analyzed element