# Views on overview analysis results

Available in...

* Big Data Platform
* Data Fabric
* Data Management Platform
* Data Services Platform
* MDM Platform
* Real-Time Big Data Platform

* TDQ\_V\_ALL\_RUN\_OVERVIEW\_ANALY: contains all analysis primary keys with the calendar time

* TDQ\_V\_LAST\_OVERVIEW\_ANALY\_EXEC: contains the primary key of the last execution of each overview analysis. This views uses TDQ\_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 uses TDQ\_V\_ALL\_RUN\_OVERVIEW\_ANALY and TDQ\_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 table

* CAL\_PK: foreign keys to the execution date of the analysis

* TIME\_PK: foreign keys to the execution time of the analysis

* AN\_RUNTIME: execution date of the analysis

TDQ\_V\_LAST\_OVERVIEW\_ANALY\_EXEC

* ANALYSIS\_PK: foreign keys to the analysis dimension table

* Last\_RUNTIME: count of last version of the analyzed element