64: where cube.elementid = map.targetdataentity; */
65:
66: /**cursor allfactt is
67: select cube.fact_longname fact_name
68: from edw_relationmapping_md_v map,edw_facts_md_v cube
69: where cube.fact_id = map.targetdataentity;**/
70:
71: ----fix bug 2109920.Exclude derived facts from the fact list---
72: cursor allfactt is
70:
71: ----fix bug 2109920.Exclude derived facts from the fact list---
72: cursor allfactt is
73: select cube1.fact_longname fact_name
74: from edw_relationmapping_md_v map1,edw_facts_md_v cube1
75: where cube1.fact_id = map1.targetdataentity
76: and cube1.fact_longname not in
77: (select distinct cube.fact_longname
78: from
75: where cube1.fact_id = map1.targetdataentity
76: and cube1.fact_longname not in
77: (select distinct cube.fact_longname
78: from
79: edw_facts_md_v cube,
80: edw_facts_md_v cube_src,
81: edw_relationmapping_md_v map where
82: map.targetdataentity=cube.fact_id
83: and map.sourcedataentity=cube_src.fact_id);
76: and cube1.fact_longname not in
77: (select distinct cube.fact_longname
78: from
79: edw_facts_md_v cube,
80: edw_facts_md_v cube_src,
81: edw_relationmapping_md_v map where
82: map.targetdataentity=cube.fact_id
83: and map.sourcedataentity=cube_src.fact_id);
84: