Views used by the OLAP Cube of the Analytical Processing feature of the Portal - 6.1

Talend Data Fabric Studio User Guide

EnrichVersion
6.1
EnrichProdName
Talend Data Fabric
task
Data Governance
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio
  • TDQ_V_OLAP_SIMPL_INDICATOR: contains all simple statistics indicator measures that do not respect the thresholds defined in the analysis

  • TDQ_V_OLAP_SUMMARY_INDICATOR: contains all summary statistics indicator measures that do not respect the thresholds defined in the analysis

  • TDQ_V_OLAP_TEXTSTAT_INDICATOR: contains all text statistics indicator measures that do not respect the thresholds defined in the analysis

Detailed description of views:

TDQ_V_OLAP_SIMPL_INDICATOR, TDQ_V_OLAP_SUMMARY_INDICATOR and TDQ_V_OLAP_TEXTSTAT_INDICATOR

  • INDV_PK: primary key

  • ELEMENT_PK: foreign keys to the analyzed element dimension tables

  • ANALYSIS_PK: foreign keys to the analysis dimension tables

  • VALUE_PK: foreign keys to the value dimension tables

  • OPTION_PK: foreign keys to the option dimension tables

  • INDICATOR_PK: foreign keys to the indicator definition dimension tables

  • CALENDAR_PK: foreign keys to the date dimension tables

  • TIME_PK: foreign keys to the time dimension tables

  • INDV_REAL_VALUE: indicator real value

  • INDV_INT_VALUE: indicator integer value

  • INDV_ROW_COUNT: number of rows when evaluating the indicator

  • INDV_VALUE_TYPE_INDICATOR: flag to tell whether it is a real value indicator

  • INDV_DTHRESH_OK: any of the flags Y or N or U which indicates whether this indicator respects the data threshold.Y means yes, N means no, U means undefined

  • INDV_ITHRESH_OK: any of the flags Y or N or U which indicates whether this indicator respects the data threshold.Y means yes, N means no, U means undefined

  • INDV_ITHRESH_PERC_OK: any of the flags Y or N or U which indicates whether this indicator respects the data threshold.Y means yes, N means no, U means undefined