OLAPSYS.OLAPFACTVIEW dependencies on ALL_OLAP_DIM_HIER_LEVEL_USES

Line 151: FROM ALL_OLAP_DIM_HIER_LEVEL_USES

147: OWNER= eOwnerName AND CUBE_NAME= eCubeName;
148:
149: CURSOR curLevelName IS SELECT V.L
150: FROM ( SELECT CHILD_LEVEL_NAME L, POSITION P
151: FROM ALL_OLAP_DIM_HIER_LEVEL_USES
152: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName
153: AND HIERARCHY_NAME= eHierName
154: UNION
155: SELECT PARENT_LEVEL_NAME L, POSITION+1

Line 156: FROM ALL_OLAP_DIM_HIER_LEVEL_USES

152: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName
153: AND HIERARCHY_NAME= eHierName
154: UNION
155: SELECT PARENT_LEVEL_NAME L, POSITION+1
156: FROM ALL_OLAP_DIM_HIER_LEVEL_USES
157: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName
158: AND HIERARCHY_NAME= eHierName) V
159: ORDER BY V.P DESC;
160:

Line 1909: FROM ALL_OLAP_DIM_HIER_LEVEL_USES

1905: OWNER= eOwnerName AND CUBE_NAME= eCubeName;
1906:
1907: CURSOR curLevelName IS SELECT V.L
1908: FROM ( SELECT CHILD_LEVEL_NAME L, POSITION P
1909: FROM ALL_OLAP_DIM_HIER_LEVEL_USES
1910: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName
1911: AND HIERARCHY_NAME= eHierName
1912: UNION
1913: SELECT PARENT_LEVEL_NAME L, POSITION+1

Line 1914: FROM ALL_OLAP_DIM_HIER_LEVEL_USES

1910: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName
1911: AND HIERARCHY_NAME= eHierName
1912: UNION
1913: SELECT PARENT_LEVEL_NAME L, POSITION+1
1914: FROM ALL_OLAP_DIM_HIER_LEVEL_USES
1915: WHERE OWNER= eOwnerName AND DIMENSION_NAME= eDimName
1916: AND HIERARCHY_NAME= eHierName) V
1917: ORDER BY V.P DESC;
1918: