# Views on dimensions

Available in...

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

* TDQ\_V\_LAST\_ANALYSIS: contains the analysis and the report identifiers with the last version number of the analysis dimension (because TDQ\_ANALYSIS is a Slowly Changing Dimension, each analysis can have several versions).

* TDQ\_V\_ANALYSIS: view on the last version of the analysis data. This view uses TDQ\_V\_LAST\_ANALYSIS

* TDQ\_V\_LAST\_ANALYZED\_ELEMENT: contains the analyzed element identifier alongside with the last version number of the analyzed element dimension

* TDQ\_V\_ANALYZED\_ELEMENT: view on the last version of the analyzed element. This view uses TDQ\_V\_LAST\_ANALYZED\_ELEMENT

* TDQ\_V\_LAST\_INDICATOR\_DEF: contains the indicator definition identifier alongside with the last version number of the indicator definition dimension

* TDQ\_V\_INDICATOR\_DEFINITION: view on the last version of the indicator definition. This view uses TDQ\_V\_LAST\_INDICATOR\_DEF

* TDQ\_V\_SIMPLE\_INDICS: This view filters the simple statistics indicators. It uses TDQ\_V\_INDICATOR\_DEFINITION

Detailed description of views:

TDQ\_V\_ANALYSIS, TDQ\_V\_ANALYZED\_ELEMENT and TDQ\_V\_INDICATOR\_DEFINITION have the same attributes (columns) as TDQ\_ANALYSIS, TDQ\_ANALYZED\_ELEMENT and TDQ\_INDICATOR\_DEFINITION respectively. For further information, see [Detailed description of tables](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/detailed-description-of-tables)

TDQ\_V\_LAST\_ANALYSIS

* AN\_UUID: analysis identifier

* REP\_UUID: report identifier

* LAST\_VERSION: last version of the analysis

TDQ\_V\_LAST\_ANALYZED\_ELEMENT

* ELT\_UUID: identifier of the analyzed element

* LAST\_VERSION: last version of the analyzed element

* ELT\_CTX\_GROUP\_ID: the context group id of the analyzed element

* ELT\_CTX\_NAME: the context name of the analyzed element

TDQ\_V\_LAST\_INDICATOR\_DEF

* IND\_UUID: indicator identifier

* LAST\_VERSION: last version of the identifier

TDQ\_V\_SIMPLE\_INDICS

* IND\_PK: primary key

* IND\_UUID: indicator identifier

* IND\_LABEL: indicator label

* IND\_CATEGORY: indicator category.

  Simple indicators such as count indicators belong to the Simple Statistics category, Count subcategory. Text indicators belong to the Text Statistics category. Mean, Median, Lower quartile, upper quartile, min value, max value belong to the Summary Statistics category. Mode belong to the Advanced Statistics category and Mode subcategory. Frequency table belong to the Advanced Statistics category and Frequencies subcategory.

* IND\_CATEG\_UUID: category identifier

And the three historization columns:

* IND\_BEGIN\_DATE

* IND\_END\_DATE

* IND\_VERSION