[Home] [Help]
1776: l_length number;
1777: done boolean;
1778: nl varchar2(1) := fnd_global.local_chr(10);
1779:
1780: l_global_ecm zpb_ecm.global_ecm;
1781: l_dim_data zpb_ecm.dimension_data;
1782: l_range_dim_data zpb_ecm.dimension_data;
1783: l_dim_ecm zpb_ecm.dimension_ecm;
1784: l_dim_time_ecm zpb_ecm.dimension_time_ecm;
1777: done boolean;
1778: nl varchar2(1) := fnd_global.local_chr(10);
1779:
1780: l_global_ecm zpb_ecm.global_ecm;
1781: l_dim_data zpb_ecm.dimension_data;
1782: l_range_dim_data zpb_ecm.dimension_data;
1783: l_dim_ecm zpb_ecm.dimension_ecm;
1784: l_dim_time_ecm zpb_ecm.dimension_time_ecm;
1785: l_dim_line_ecm zpb_ecm.dimension_line_ecm;
1778: nl varchar2(1) := fnd_global.local_chr(10);
1779:
1780: l_global_ecm zpb_ecm.global_ecm;
1781: l_dim_data zpb_ecm.dimension_data;
1782: l_range_dim_data zpb_ecm.dimension_data;
1783: l_dim_ecm zpb_ecm.dimension_ecm;
1784: l_dim_time_ecm zpb_ecm.dimension_time_ecm;
1785: l_dim_line_ecm zpb_ecm.dimension_line_ecm;
1786: l_global_attr_ecm zpb_ecm.global_attr_ecm;
1779:
1780: l_global_ecm zpb_ecm.global_ecm;
1781: l_dim_data zpb_ecm.dimension_data;
1782: l_range_dim_data zpb_ecm.dimension_data;
1783: l_dim_ecm zpb_ecm.dimension_ecm;
1784: l_dim_time_ecm zpb_ecm.dimension_time_ecm;
1785: l_dim_line_ecm zpb_ecm.dimension_line_ecm;
1786: l_global_attr_ecm zpb_ecm.global_attr_ecm;
1787: l_attr_ecm zpb_ecm.attr_ecm;
1780: l_global_ecm zpb_ecm.global_ecm;
1781: l_dim_data zpb_ecm.dimension_data;
1782: l_range_dim_data zpb_ecm.dimension_data;
1783: l_dim_ecm zpb_ecm.dimension_ecm;
1784: l_dim_time_ecm zpb_ecm.dimension_time_ecm;
1785: l_dim_line_ecm zpb_ecm.dimension_line_ecm;
1786: l_global_attr_ecm zpb_ecm.global_attr_ecm;
1787: l_attr_ecm zpb_ecm.attr_ecm;
1788: l_attr_nameFrag varchar2(500);
1781: l_dim_data zpb_ecm.dimension_data;
1782: l_range_dim_data zpb_ecm.dimension_data;
1783: l_dim_ecm zpb_ecm.dimension_ecm;
1784: l_dim_time_ecm zpb_ecm.dimension_time_ecm;
1785: l_dim_line_ecm zpb_ecm.dimension_line_ecm;
1786: l_global_attr_ecm zpb_ecm.global_attr_ecm;
1787: l_attr_ecm zpb_ecm.attr_ecm;
1788: l_attr_nameFrag varchar2(500);
1789:
1782: l_range_dim_data zpb_ecm.dimension_data;
1783: l_dim_ecm zpb_ecm.dimension_ecm;
1784: l_dim_time_ecm zpb_ecm.dimension_time_ecm;
1785: l_dim_line_ecm zpb_ecm.dimension_line_ecm;
1786: l_global_attr_ecm zpb_ecm.global_attr_ecm;
1787: l_attr_ecm zpb_ecm.attr_ecm;
1788: l_attr_nameFrag varchar2(500);
1789:
1790: m_dimension_en zpb_md_records.dimensions_entry;
1783: l_dim_ecm zpb_ecm.dimension_ecm;
1784: l_dim_time_ecm zpb_ecm.dimension_time_ecm;
1785: l_dim_line_ecm zpb_ecm.dimension_line_ecm;
1786: l_global_attr_ecm zpb_ecm.global_attr_ecm;
1787: l_attr_ecm zpb_ecm.attr_ecm;
1788: l_attr_nameFrag varchar2(500);
1789:
1790: m_dimension_en zpb_md_records.dimensions_entry;
1791: m_dimension_tl_en zpb_md_records.dimensions_tl_entry;
1864: l_pp_hiert_start_time date;
1865:
1866: begin
1867: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';
1868: l_global_ecm := zpb_ecm.get_global_ecm (p_aw);
1869: l_global_attr_ecm := zpb_ecm.get_global_attr_ecm(p_aw);
1870:
1871: l_langs :=zpb_aw.interp
1872: ('shw CM.GETDIMVALUES('''||l_aw||l_global_ecm.LangDim||''')');
1865:
1866: begin
1867: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';
1868: l_global_ecm := zpb_ecm.get_global_ecm (p_aw);
1869: l_global_attr_ecm := zpb_ecm.get_global_attr_ecm(p_aw);
1870:
1871: l_langs :=zpb_aw.interp
1872: ('shw CM.GETDIMVALUES('''||l_aw||l_global_ecm.LangDim||''')');
1873:
1906: m_dimension_exists := true;
1907: end;
1908:
1909:
1910: l_dim_data := zpb_ecm.get_dimension_data (l_dim, p_aw);
1911: l_dim_ecm := zpb_ecm.get_dimension_ecm (l_dim, p_aw);
1912:
1913: zpb_aw.execute('push '||l_aw||l_dim_data.ExpObj);
1914:
1907: end;
1908:
1909:
1910: l_dim_data := zpb_ecm.get_dimension_data (l_dim, p_aw);
1911: l_dim_ecm := zpb_ecm.get_dimension_ecm (l_dim, p_aw);
1912:
1913: zpb_aw.execute('push '||l_aw||l_dim_data.ExpObj);
1914:
1915: m_dimension_en.AWName := l_dim_data.ExpObj;
2615: l_attr := substr (l_attrs, ai, aj-ai);
2616: ai := aj+1;
2617: end if;
2618:
2619: l_attr_ecm := zpb_ecm.get_attr_ecm(l_attr, l_global_attr_ecm, p_aw);
2620:
2621: zpb_aw.execute ('lmt '||l_aw||l_global_ecm.AttrDim||' to '''|| l_attr||'''');
2622:
2623: -- explicitly exclude timespan and non-displayable attributes
2676: -- when NO_DATA_FOUND then
2677: -- SELECT zpb_dimensions_seq.NEXTVAL INTO m_attr_rangedim_en.DimensionId FROM DUAL;
2678: -- end;
2679:
2680: l_range_dim_data := zpb_ecm.get_dimension_data (m_attr_rangedim_en.EPBId, p_aw);
2681:
2682: m_attr_rangedim_en.PersCWMName := zpb_metadata_names.get_dimension_cwm2_name('PRS', l_attrId);
2683: m_attr_rangedim_en.SharCWMName := zpb_metadata_names.get_dimension_cwm2_name(p_sharedAw, l_attrId);
2684: m_attr_rangedim_en.SharTableId :=0;
2861:
2862: zpb_aw.execute('lmt '||l_aw||l_global_ecm.LangDim||' to '''||
2863: l_lang||'''');
2864:
2865: l_range_dim_data := zpb_ecm.get_dimension_data (m_attr_rangedim_en.EPBId, p_aw);
2866:
2867: m_attr_rangedim_tl_en.Name := l_range_dim_data.Sdsc;
2868: m_attr_rangedim_tl_en.LongName := l_range_dim_data.Ldsc;
2869: m_attr_rangedim_tl_en.PluralName := l_range_dim_data.PlSdsc;
3004: m_attr_table_col_id := insertAttrTableColRecord(m_attr_table_col_en);
3005:
3006:
3007: if (l_dim_data.Type = 'TIME') then
3008: l_dim_time_ecm := zpb_ecm.get_dimension_time_ecm(l_dim, p_aw);
3009:
3010: m_attr_en.DimensionId := m_dimension_en.DimensionId;
3011: m_attr_en.FEMAttrId := null;
3012: m_attr_en.RangeDimId := null;
3080: end if; -- done special attributes for time dimension
3081:
3082: -- build special attributes for line dimension
3083: if (l_dim_data.Type = 'LINE') then
3084: l_dim_line_ecm := zpb_ecm.get_dimension_line_ecm(l_dim, p_aw);
3085:
3086: m_attr_en.DimensionId := m_dimension_en.DimensionId;
3087: m_attr_en.RangeDimId := null;
3088: m_attr_en.FEMAttrId := null;
3176:
3177: zpb_aw.execute('lmt '||l_aw||l_global_ecm.LangDim||' to '''||
3178: l_lang||'''');
3179:
3180: l_dim_data := zpb_ecm.get_dimension_data (l_dim, p_aw);
3181: m_dimension_tl_en.Name := l_dim_data.Sdsc;
3182: m_dimension_tl_en.LongName := l_dim_data.Ldsc;
3183: m_dimension_tl_en.PluralName := l_dim_data.PlSdsc;
3184: m_dimension_tl_en.PluralLongName := l_dim_data.PlLdsc;
3223: l_gid boolean;
3224: l_hiers varchar2(1000);
3225: l_hier varchar2(30);
3226: nl varchar2(1) := fnd_global.local_chr(10);
3227: l_dim_ecm zpb_ecm.dimension_ecm;
3228:
3229: -- interface layer table entrieds
3230: m_cube_en zpb_md_records.cubes_entry;
3231: m_table_en zpb_md_records.tables_entry;
3297: l_dim := substr (p_dims, i, j-i);
3298: i := j+1;
3299: end if;
3300:
3301: l_dim_ecm := zpb_ecm.get_dimension_ecm(l_dim, p_aw);
3302:
3303: -- initialize cube_dim entry
3304: m_cube_dims_en.cubeId := m_cube_num;
3305:
3446: l_awQual varchar2(30);
3447: l_objName varchar2(60);
3448: l_dims varchar2(500);
3449: l_count number;
3450: l_global_ecm zpb_ecm.global_ecm;
3451: hi number;
3452: hj number;
3453: l_curMeasures varchar2(4000);
3454: l_curMeas varchar2(64);
3473: bus_area_id_num := sys_context('ZPB_CONTEXT', 'business_area_id');
3474:
3475: l_awQual := zpb_aw.get_schema||'.'||p_aw||'!';
3476:
3477: l_global_ecm := zpb_ecm.get_global_ecm (p_aw);
3478:
3479: l_instType := zpb_aw.interp ('shw CM.GETINSTOBJECT('''||p_instance||
3480: ''' ''TYPE'')');
3481:
3896: i number;
3897: j number;
3898: entry number;
3899: nl varchar2(1) := fnd_global.local_chr(10);
3900: l_global_ecm zpb_ecm.global_ecm;
3901:
3902: -- measure table entry
3903: m_meas_en zpb_md_records.measures_entry;
3904: m_meas_id number;
3936: l_awQual := l_schema||p_aw||'!';
3937:
3938: bus_area_id_num := sys_context('ZPB_CONTEXT', 'business_area_id');
3939:
3940: l_global_ecm := zpb_ecm.get_global_ecm(p_aw);
3941: zpb_aw.execute ('push '||l_awQual||'MEASURE');
3942: zpb_aw.execute ('lmt '||l_awQual||'MEASURE to '''||p_meas||'''');
3943:
3944: l_measType := zpb_aw.interp('shw '||l_awQual||l_global_ecm.MeasTypeRel);
4206: ai number;
4207: aj number;
4208: done boolean;
4209:
4210: l_dim_ecm zpb_ecm.dimension_ecm;
4211: l_global_ecm zpb_ecm.global_ecm;
4212:
4213: -- measure entry
4214: m_meas_en zpb_md_records.measures_entry;
4207: aj number;
4208: done boolean;
4209:
4210: l_dim_ecm zpb_ecm.dimension_ecm;
4211: l_global_ecm zpb_ecm.global_ecm;
4212:
4213: -- measure entry
4214: m_meas_en zpb_md_records.measures_entry;
4215: m_meas_id number;
4239: zpb_aw.execute ('aw attach '||zpb_aw.get_schema||'.'||p_aw||' first');
4240:
4241: l_gid := false;
4242: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';
4243: l_global_ecm := zpb_ecm.get_global_ecm(p_aw);
4244:
4245: zpb_aw.execute('push oknullstatus '||l_global_ecm.AttrDim);
4246: zpb_aw.execute('oknullstatus = yes');
4247:
4699: i number;
4700: j number;
4701: l_gid boolean;
4702: l_aw varchar2(30);
4703: l_global_ecm zpb_ecm.global_ecm;
4704: l_dim_ecm zpb_ecm.dimension_ecm;
4705: nl varchar2(1) := fnd_global.local_chr(10);
4706: l_cpr_meas_cube varchar2(64);
4707: l_frmcpr varchar2(16);
4700: j number;
4701: l_gid boolean;
4702: l_aw varchar2(30);
4703: l_global_ecm zpb_ecm.global_ecm;
4704: l_dim_ecm zpb_ecm.dimension_ecm;
4705: nl varchar2(1) := fnd_global.local_chr(10);
4706: l_cpr_meas_cube varchar2(64);
4707: l_frmcpr varchar2(16);
4708:
4779: p_read_only => FND_API.G_TRUE);
4780: end if;
4781:
4782:
4783: l_global_ecm := zpb_ecm.get_global_ecm (p_persAw);
4784: l_aw := zpb_aw.get_schema||'.'||p_persAw||'!';
4785: l_gid := false;
4786:
4787:
4852: m_cube_dims_en.ColumnId := insertColumnRecord(m_column_en);
4853:
4854: m_relation_id := insertCubeDimsRecord(m_cube_dims_en);
4855:
4856: l_dim_ecm := zpb_ecm.get_dimension_ecm(l_dim, p_sharedAw);
4857:
4858: if (zpb_aw.interp('shw obj(dimmax '''||l_aw||l_dim_ecm.HierDim||
4859: ''')') <> '0') then
4860: zpb_aw.execute ('lmt '||l_aw||l_dim_Ecm.HierDim||' to all');
4957: l_hiers varchar2(1000);
4958: l_hier varchar2(30);
4959: l_dim varchar2(30);
4960: nl varchar2(1) := fnd_global.local_chr(10);
4961: l_dim_ecm zpb_ecm.dimension_ecm;
4962:
4963: -- md table entries
4964: m_cube_en zpb_md_records.cubes_entry;
4965: m_table_en zpb_md_records.tables_entry;
5024: else
5025: l_dim := substr (p_dims, i, j-i);
5026: i := j+1;
5027: end if;
5028: l_dim_ecm := zpb_ecm.get_dimension_ecm(l_dim, p_aw);
5029:
5030: -- initialize dimension entry
5031: m_column_en.ColumnName := zpb_metadata_names.get_dimension_column(l_dim);
5032: m_column_en.ColumnType := 'MEMBER_COLUMN';
5382: aj number;
5383: l_length number;
5384: nl varchar2(1) := fnd_global.local_chr(10);
5385:
5386: l_global_ecm zpb_ecm.global_ecm;
5387: l_dim_data zpb_ecm.dimension_data;
5388: l_range_dim_data zpb_ecm.dimension_data;
5389: l_dim_ecm zpb_ecm.dimension_ecm;
5390: l_dim_time_ecm zpb_ecm.dimension_time_ecm;
5383: l_length number;
5384: nl varchar2(1) := fnd_global.local_chr(10);
5385:
5386: l_global_ecm zpb_ecm.global_ecm;
5387: l_dim_data zpb_ecm.dimension_data;
5388: l_range_dim_data zpb_ecm.dimension_data;
5389: l_dim_ecm zpb_ecm.dimension_ecm;
5390: l_dim_time_ecm zpb_ecm.dimension_time_ecm;
5391: l_global_attr_ecm zpb_ecm.global_attr_ecm;
5384: nl varchar2(1) := fnd_global.local_chr(10);
5385:
5386: l_global_ecm zpb_ecm.global_ecm;
5387: l_dim_data zpb_ecm.dimension_data;
5388: l_range_dim_data zpb_ecm.dimension_data;
5389: l_dim_ecm zpb_ecm.dimension_ecm;
5390: l_dim_time_ecm zpb_ecm.dimension_time_ecm;
5391: l_global_attr_ecm zpb_ecm.global_attr_ecm;
5392: l_attr_ecm zpb_ecm.attr_ecm;
5385:
5386: l_global_ecm zpb_ecm.global_ecm;
5387: l_dim_data zpb_ecm.dimension_data;
5388: l_range_dim_data zpb_ecm.dimension_data;
5389: l_dim_ecm zpb_ecm.dimension_ecm;
5390: l_dim_time_ecm zpb_ecm.dimension_time_ecm;
5391: l_global_attr_ecm zpb_ecm.global_attr_ecm;
5392: l_attr_ecm zpb_ecm.attr_ecm;
5393:
5386: l_global_ecm zpb_ecm.global_ecm;
5387: l_dim_data zpb_ecm.dimension_data;
5388: l_range_dim_data zpb_ecm.dimension_data;
5389: l_dim_ecm zpb_ecm.dimension_ecm;
5390: l_dim_time_ecm zpb_ecm.dimension_time_ecm;
5391: l_global_attr_ecm zpb_ecm.global_attr_ecm;
5392: l_attr_ecm zpb_ecm.attr_ecm;
5393:
5394: bus_area_id_num number;
5387: l_dim_data zpb_ecm.dimension_data;
5388: l_range_dim_data zpb_ecm.dimension_data;
5389: l_dim_ecm zpb_ecm.dimension_ecm;
5390: l_dim_time_ecm zpb_ecm.dimension_time_ecm;
5391: l_global_attr_ecm zpb_ecm.global_attr_ecm;
5392: l_attr_ecm zpb_ecm.attr_ecm;
5393:
5394: bus_area_id_num number;
5395:
5388: l_range_dim_data zpb_ecm.dimension_data;
5389: l_dim_ecm zpb_ecm.dimension_ecm;
5390: l_dim_time_ecm zpb_ecm.dimension_time_ecm;
5391: l_global_attr_ecm zpb_ecm.global_attr_ecm;
5392: l_attr_ecm zpb_ecm.attr_ecm;
5393:
5394: bus_area_id_num number;
5395:
5396: -- language looping
5466: dims.dimension_id = attr2.dimension_id;
5467:
5468: begin
5469: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';
5470: l_global_ecm := zpb_ecm.get_global_ecm (p_aw);
5471: l_global_attr_ecm := zpb_ecm.get_global_attr_ecm(p_aw);
5472:
5473: -- save start time. At the end we will remove all scoping entries that were
5474: -- created prior to this time, as they are no longer valid
5467:
5468: begin
5469: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';
5470: l_global_ecm := zpb_ecm.get_global_ecm (p_aw);
5471: l_global_attr_ecm := zpb_ecm.get_global_attr_ecm(p_aw);
5472:
5473: -- save start time. At the end we will remove all scoping entries that were
5474: -- created prior to this time, as they are no longer valid
5475: select sysdate into l_start_time from dual;
5516: where hier.dimension_id = dims.dimension_id and
5517: dims.bus_area_id = bus_area_id_num and
5518: dims.dimension_id = l_dimension_id);
5519:
5520: l_dim_data := zpb_ecm.get_dimension_data (l_dim, p_aw);
5521: l_dim_ecm := zpb_ecm.get_dimension_ecm (l_dim, p_aw);
5522:
5523: -- see if we need to later create a scope entry for null hierarchy of this dimension
5524: select count(hierarchy_id) into l_nullHierCnt
5517: dims.bus_area_id = bus_area_id_num and
5518: dims.dimension_id = l_dimension_id);
5519:
5520: l_dim_data := zpb_ecm.get_dimension_data (l_dim, p_aw);
5521: l_dim_ecm := zpb_ecm.get_dimension_ecm (l_dim, p_aw);
5522:
5523: -- see if we need to later create a scope entry for null hierarchy of this dimension
5524: select count(hierarchy_id) into l_nullHierCnt
5525: from zpb_hierarchies