DBA Data[Home] [Help]

OLAPSYS.OLAPDIMVIEW dependencies on ALL_OLAP_DIMENSIONS

Line 149: FROM ALL_OLAP_DIMENSIONS WHERE DIMENSION_NAME = eDimName AND

145:
146: TYPE colLvlList_t IS TABLE OF ALL_OLAP_LEVEL_KEY_COLUMN_USES.COLUMN_NAME%TYPE;
147:
148: CURSOR curDispName IS SELECT DISPLAY_NAME
149: FROM ALL_OLAP_DIMENSIONS WHERE DIMENSION_NAME = eDimName AND
150: OWNER= eOwnerName;
151:
152: CURSOR curDimName IS SELECT DIMENSION_NAME
153: FROM ALL_OLAP_FACT_LEVEL_USES WHERE FACT_TABLE_NAME= eFactName AND

Line 1846: FROM ALL_OLAP_DIMENSIONS WHERE DIMENSION_NAME = eDimName AND

1842:
1843: TYPE colLvlList_t IS TABLE OF ALL_OLAP_LEVEL_KEY_COLUMN_USES.COLUMN_NAME%TYPE;
1844:
1845: CURSOR curDispName IS SELECT DISPLAY_NAME
1846: FROM ALL_OLAP_DIMENSIONS WHERE DIMENSION_NAME = eDimName AND
1847: OWNER= eOwnerName;
1848:
1849: CURSOR curDimName IS SELECT distinct DIMENSION_NAME
1850: FROM ALL_OLAP_FACT_LEVEL_USES WHERE FACT_TABLE_NAME= eFactName AND