[Home] [Help]
192: relation_col parent_fk, level
193: from bsc_sys_dim_level_rels rels,
194: bsc_sys_dim_levels_b levels,
195: bsc_sys_dim_levels_b parent_levels,
196: bsc_kpi_dim_levels_b kpi_levels
197: where rels.dim_level_id = levels.dim_level_id
198: and levels.level_table_name = kpi_levels.level_table_name
199: and rels.parent_dim_level_id = parent_levels.dim_level_id
200: and kpi_levels.indicator = p_indicator
938: cv CurTyp;
939:
940: CURSOR cFilter(pIndicator IN NUMBER, pConfig IN NUMBER) IS
941: SELECT count(1)
942: FROM BSC_KPI_DIM_LEVELS_B K, BSC_SYS_DIM_LEVELS_B S
943: WHERE UPPER(K.LEVEL_TABLE_NAME) = UPPER(S.LEVEL_TABLE_NAME)
944: AND K.INDICATOR = pIndicator
945: AND K.DIM_SET_ID = pConfig
946: AND UPPER(S.LEVEL_VIEW_NAME) <> UPPER(K.LEVEL_VIEW_NAME)
1065: Function GetSourceDimensionSet(Indic IN NUMBER, DimSet IN NUMBER) return VARCHAR2 IS
1066:
1067: CURSOR cSourceDimSet IS
1068: SELECT NVL(SOURCE, 'BSC') DSSOURCE
1069: FROM BSC_SYS_DIM_LEVELS_B S, BSC_KPI_DIM_LEVELS_B K
1070: WHERE S.LEVEL_TABLE_NAME = K.LEVEL_TABLE_NAME
1071: AND K.INDICATOR = Indic AND K.DIM_SET_ID = DimSet AND K.STATUS = 2;
1072: l_ret VARCHAR2(100);
1073: cv CurTyp;
2484: l_stmt varchar2(1000);
2485: l_return varchar2(1000) := null;
2486: cv CurTyp;
2487: CURSOR cLevelViewName (pIndicator IN NUMBER, pConfiguration IN NUMBER, pKeyCol IN VARCHAR2) IS
2488: SELECT LEVEL_VIEW_NAME FROM BSC_KPI_DIM_LEVELS_B
2489: WHERE INDICATOR = pIndicator
2490: AND DIM_SET_ID = pConfiguration
2491: AND LEVEL_PK_COL = pKeyCol;
2492: BEGIN
2740: BEGIN
2741: IF (gRecDims IS NULL) THEN
2742: gRecDims := getRecursiveDimensions;
2743: END IF;
2744: l_stmt := 'select 1 from bsc_kpi_dim_levels_b where indicator =:1
2745: and level_pk_col = :2
2746: and level_table_name in (
2747: select level_table_name from bsc_sys_dim_levels_b
2748: where short_name in ('|| gRecDims||')