Views on dimensions

• 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