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

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

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!