[Home] [Help]
2348: -- configured in BSC_DB_TABLES_COLS but it does not exists in BSC_DB_MEASURES_COLS_VL
2349: -- because the user could delete the measure. I am changing the query to return
2350: -- default values in case the measure does not exists in BSC_DB_MEASURES_COLS_VL
2351:
2352: -- SUPPORT_BSC_BIS_MEASURES: Only BSC measures exists in bsc_db_measure_cols_vl.
2353: -- For BIS measures by design we assumed that projection method is 0 (no projection)
2354: -- and measure type is 1 (Total)
2355: CURSOR c_data_columns (p_table_name VARCHAR2, p_column_type VARCHAR2) IS
2356: SELECT c.column_name, c.source_formula,
2355: CURSOR c_data_columns (p_table_name VARCHAR2, p_column_type VARCHAR2) IS
2356: SELECT c.column_name, c.source_formula,
2357: DECODE(NVL(c.source,'BSC'),'BSC',NVL(m.projection_id, 0),0),
2358: DECODE(NVL(c.source,'BSC'),'BSC',NVL(m.measure_type, 1),1)
2359: FROM bsc_db_tables_cols c, bsc_db_measure_cols_vl m
2360: WHERE c.column_name = m.measure_col (+) AND
2361: c.table_name = p_table_name AND c.column_type = p_column_type;
2362:
2363: h_column_type_a VARCHAR2(1);
2364:
2365: h_column_name bsc_db_tables_cols.column_name%TYPE;
2366: h_source_formula bsc_db_tables_cols.source_formula%TYPE;
2367: h_projection_id bsc_db_tables_cols.projection_id%TYPE;
2368: h_measure_type bsc_db_measure_cols_vl.measure_type%TYPE;
2369:
2370: BEGIN
2371: h_column_type_a := 'A';
2372: