# Views on comparison analysis results

Available in...

* Big Data Platform
* Data Fabric
* Data Management Platform
* Data Services Platform
* MDM Platform
* Qlik Cloud Enterprise Edition
* Qlik Talend Cloud Enterprise Edition
* Qlik Talend Cloud Premium Edition
* Real-Time Big Data Platform

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

* TDQ\_V\_LAST\_MATCH\_ANALYSIS\_EXEC: contains the primary key of the last execution of each comparison analysis. This view uses TDQ\_V\_ALL\_RUN\_MATCH\_ANALYSIS

* TDQ\_V\_LAST\_RUN\_MATCH\_ANALYSIS: 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\_MATCH\_ANALYSIS and TDQ\_V\_LAST\_MATCH\_ANALYSIS\_EXEC

Detailed description of views:

TDQ\_V\_ALL\_RUN\_MATCH\_ANALYSIS and TDQ\_V\_LAST\_RUN\_MATCH\_ANALYSIS

* 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\_MATCH\_ANALYSIS\_EXEC

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

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