[Home] [Help]
View: BISBV_PERFORMANCE_MEASURES
View Text
SELECT BIS_INDICATORS.INDICATOR_ID MEASURE_ID
, BIS_INDICATORS.SHORT_NAME MEASURE_SHORT_NAME
, BIS_INDICATORS_TL.NAME MEASURE_NAME
, BIS_INDICATORS_TL.DESCRIPTION DESCRIPTION
, BIS_INDICATOR_DIMENSIONS_DIM1.DIMENSION_ID DIMENSION1_ID
, BIS_INDICATOR_DIMENSIONS_DIM2.DIMENSION_ID DIMENSION2_ID
, BIS_INDICATOR_DIMENSIONS_DIM3.DIMENSION_ID DIMENSION3_ID
, BIS_INDICATOR_DIMENSIONS_DIM4.DIMENSION_ID DIMENSION4_ID
, BIS_INDICATOR_DIMENSIONS_DIM5.DIMENSION_ID DIMENSION5_ID
, BIS_INDICATOR_DIMENSIONS_DIM6.DIMENSION_ID DIMENSION6_ID
, BIS_INDICATOR_DIMENSIONS_DIM7.DIMENSION_ID DIMENSION7_ID
, BIS_INDICATORS.UOM_CLASS UNIT_OF_MEASURE_CLASS
, BIS_INDICATORS.ACTUAL_DATA_SOURCE_TYPE ACTUAL_DATA_SOURCE_TYPE
, BIS_INDICATORS.ACTUAL_DATA_SOURCE ACTUAL_DATA_SOURCE
, BIS_INDICATORS.FUNCTION_NAME FUNCTION_NAME
, BIS_INDICATORS.COMPARISON_SOURCE COMPARISON_SOURCE
, BIS_INDICATORS.INCREASE_IN_MEASURE INCREASE_IN_MEASURE
, BIS_INDICATORS.ENABLE_LINK ENABLE_LINK
, BIS_INDICATORS.DATASET_ID DATASET_ID
, BIS_INDICATORS.ENABLED ENABLED
, NVL(BIS_INDICATORS.OBSOLETE
, 'F') OBSOLETE
, BIS_INDICATORS.MEASURE_TYPE MEASURE_TYPE
FROM BIS_INDICATORS BIS_INDICATORS
, BIS_INDICATORS_TL BIS_INDICATORS_TL
, BIS_INDICATOR_DIMENSIONS BIS_INDICATOR_DIMENSIONS_DIM1
, BIS_INDICATOR_DIMENSIONS BIS_INDICATOR_DIMENSIONS_DIM2
, BIS_INDICATOR_DIMENSIONS BIS_INDICATOR_DIMENSIONS_DIM3
, BIS_INDICATOR_DIMENSIONS BIS_INDICATOR_DIMENSIONS_DIM4
, BIS_INDICATOR_DIMENSIONS BIS_INDICATOR_DIMENSIONS_DIM5
, BIS_INDICATOR_DIMENSIONS BIS_INDICATOR_DIMENSIONS_DIM6
, BIS_INDICATOR_DIMENSIONS BIS_INDICATOR_DIMENSIONS_DIM7
WHERE BIS_INDICATORS.INDICATOR_ID = BIS_INDICATORS_TL.INDICATOR_ID
AND BIS_INDICATORS_TL.LANGUAGE = USERENV('LANG')
AND BIS_INDICATORS.INDICATOR_ID = BIS_INDICATOR_DIMENSIONS_DIM1.INDICATOR_ID(+)
AND 1 = BIS_INDICATOR_DIMENSIONS_DIM1.SEQUENCE_NO(+)
AND BIS_INDICATORS.INDICATOR_ID = BIS_INDICATOR_DIMENSIONS_DIM2.INDICATOR_ID(+)
AND 2 = BIS_INDICATOR_DIMENSIONS_DIM2.SEQUENCE_NO(+)
AND BIS_INDICATORS.INDICATOR_ID = BIS_INDICATOR_DIMENSIONS_DIM3.INDICATOR_ID(+)
AND 3 = BIS_INDICATOR_DIMENSIONS_DIM3.SEQUENCE_NO(+)
AND BIS_INDICATORS.INDICATOR_ID = BIS_INDICATOR_DIMENSIONS_DIM4.INDICATOR_ID(+)
AND 4 = BIS_INDICATOR_DIMENSIONS_DIM4.SEQUENCE_NO(+)
AND BIS_INDICATORS.INDICATOR_ID = BIS_INDICATOR_DIMENSIONS_DIM5.INDICATOR_ID(+)
AND 5 = BIS_INDICATOR_DIMENSIONS_DIM5.SEQUENCE_NO(+)
AND BIS_INDICATORS.INDICATOR_ID = BIS_INDICATOR_DIMENSIONS_DIM6.INDICATOR_ID(+)
AND 6 = BIS_INDICATOR_DIMENSIONS_DIM6.SEQUENCE_NO(+)
AND BIS_INDICATORS.INDICATOR_ID = BIS_INDICATOR_DIMENSIONS_DIM7.INDICATOR_ID(+)
AND 7 = BIS_INDICATOR_DIMENSIONS_DIM7.SEQUENCE_NO(+) WITH READ ONLY
Columns
Name |
MEASURE_ID |
MEASURE_SHORT_NAME |
MEASURE_NAME |
DESCRIPTION |
DIMENSION1_ID |
DIMENSION2_ID |
DIMENSION3_ID |
DIMENSION4_ID |
DIMENSION5_ID |
DIMENSION6_ID |
DIMENSION7_ID |
UNIT_OF_MEASURE_CLASS |