DBA Data[Home] [Help]

OLAPSYS.OLAPFACTVIEW dependencies on ALL_OLAP_CUBES

Line 199: from ALL_OLAP_CUBES a, ALL_OLAP_CUBE_MEASURES b, ALL_OLAP_CUBE_MEASURE_MAPS c

195: and c.fact_table_owner = eOwnerName
196: and c.fact_table_name = eFactName;
197:
198: CURSOR curFactName IS SELECT distinct c.fact_table_name
199: from ALL_OLAP_CUBES a, ALL_OLAP_CUBE_MEASURES b, ALL_OLAP_CUBE_MEASURE_MAPS c
200: where a.owner = b.owner
201: and a.cube_name = b.cube_name
202: and b.owner = c.owner
203: and b.cube_name = c.cube_name

Line 209: from ALL_OLAP_CUBES a, ALL_OLAP_CUBE_MEASURES b, ALL_OLAP_CUBE_MEASURE_MAPS c

205: and a.owner = eOwnerName
206: and a.cube_name = eCubeName;
207:
208: CURSOR curUnitName IS SELECT distinct c.column_name
209: from ALL_OLAP_CUBES a, ALL_OLAP_CUBE_MEASURES b, ALL_OLAP_CUBE_MEASURE_MAPS c
210: where a.owner = b.owner
211: and a.cube_name = b.cube_name
212: and b.owner = c.owner
213: and b.cube_name = c.cube_name

Line 1957: from ALL_OLAP_CUBES a, ALL_OLAP_CUBE_MEASURES b, ALL_OLAP_CUBE_MEASURE_MAPS c

1953: and c.fact_table_owner = eOwnerName
1954: and c.fact_table_name = eFactName;
1955:
1956: CURSOR curFactName IS SELECT distinct c.fact_table_name
1957: from ALL_OLAP_CUBES a, ALL_OLAP_CUBE_MEASURES b, ALL_OLAP_CUBE_MEASURE_MAPS c
1958: where a.owner = b.owner
1959: and a.cube_name = b.cube_name
1960: and b.owner = c.owner
1961: and b.cube_name = c.cube_name

Line 1967: from ALL_OLAP_CUBES a, ALL_OLAP_CUBE_MEASURES b, ALL_OLAP_CUBE_MEASURE_MAPS c

1963: and a.owner = eOwnerName
1964: and a.cube_name = eCubeName;
1965:
1966: CURSOR curUnitName IS SELECT distinct c.column_name
1967: from ALL_OLAP_CUBES a, ALL_OLAP_CUBE_MEASURES b, ALL_OLAP_CUBE_MEASURE_MAPS c
1968: where a.owner = b.owner
1969: and a.cube_name = b.cube_name
1970: and b.owner = c.owner
1971: and b.cube_name = c.cube_name