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

Talend Studio User Guide

Version
Cloud
7.3
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Available in...

Big Data Platform

Data Fabric

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

  • 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