[Home] [Help]
1054: end loop;
1055: create_dim_program(p_dimension,l_levels,l_parent_child,l_zero_levels,l_snowflake_levels);
1056: end loop;
1057: end if;
1058: --setting the kpi limit cubes is now done outside the program in bsc_aw_load_dim.set_kpi_limit_variables
1059: --
1060: /*deletes for dimensions
1061: delete are handled in the following way
1062: delete table has 2 columns. dim_level and delete_value. say we have geog dim. city,state,country
1091: p_dimension.relation_name||'('||p_dimension.dim_name||' '||p_level_group.parent_child(j).child_level||' '||
1092: p_dimension.level_name_dim||' \'''||p_level_group.parent_child(j).parent_level||'.'||
1093: p_level_group.parent_child(j).child_level||
1094: '\''))=TRUE --');
1095: --setting of kpi limit cubes is done in bsc_aw_load_dim.set_kpi_limit_variables
1096: end if;
1097: end loop;
1098: bsc_aw_utility.trim_g_commands(g_commands,3,null);
1099: bsc_aw_utility.add_g_commands(g_commands,'sql close c1');
1273: bsc_aw_utility.add_g_commands(g_commands,'sql fetch c1 loop into --');
1274: bsc_aw_utility.add_g_commands(g_commands,':match '||p_dimension.level_groups(1).levels(1).level_name||' --');
1275: bsc_aw_utility.add_g_commands(g_commands,':'||p_dimension.dim_name||'.LB('||
1276: p_dimension.dim_name||' '||p_dimension.level_groups(1).levels(1).level_name||') --');
1277: --we set kpi limit cubes in bsc_aw_load_dim.set_kpi_limit_variables
1278: --mark change for managers
1279: bsc_aw_utility.add_g_commands(g_commands,':match '||p_dimension.level_groups(1).levels(1).level_name||' --');
1280: bsc_aw_utility.add_g_commands(g_commands,':'||p_dimension.dim_name||'.LB('||
1281: p_dimension.dim_name||' '||p_dimension.level_groups(1).levels(1).level_name||') --');
2473: end if;
2474: if p_new_version>p_old_version then
2475: if p_old_version<2 then
2476: /*upgrade to handle 5064802 */
2477: bsc_aw_load_dim.upgrade_load_sync_all_dim;
2478: end if;
2479: end if;
2480: Exception when others then
2481: log_n('Exception in upgrade '||sqlerrm);