VIEW: OLAPSYS.ALL$OLAP_DIM_ATTR_USES

Source

View Text - Preformatted

SELECT
/*+ ORDERED */
  u.username owner
, d.name dimension_name
, dat.physicalname dim_attribute_name
, lvl.physicalname level_name
, lat.name lvl_attribute_name
FROM
  dba_users u
, sys.obj$ d
, cwm$dimensionattribute dat
, cwm$itemuse use1
, cwm$itemuse use2
, cwm$levelattribute lat
, cwm$level lvl
, sys.dimlevel$ l
, sys.dimattr$ a
, sys.col$ c
WHERE u.user_id = d.owner#
AND d.type# = 43 /* DIMENSION */
AND (   cwm$util.dimension_tables_visible(d.obj#) = 'Y'
     OR EXISTS /* SELECT ANY TABLE, CREATE, ALTER, DROP ANY DIMENSION */
       (SELECT null FROM v$enabledprivs
        WHERE priv_number IN (-47,-215,-216,-217)))
AND d.obj# = dat.itemcontainer_irid
AND dat.irid = use1.mappable_irid
AND use1.operation_irid = use2.operation_irid_1
AND use2.mappable_irid = lat.irid
AND lat.itemcontainer_irid = lvl.irid
AND lvl.dimension_irid = l.dimobj#
AND l.dimobj# = a.dimobj#
AND l.levelid# = a.levelid#
AND a.detailobj# = c.obj#
AND a.col# = c.col#
AND lvl.physicalname = l.levelname
AND lat.type_irid = c.obj#
AND lat.physicalname = c.name
WITH READ ONLY

View Text - HTML Formatted

SELECT /*+ ORDERED */ U.USERNAME OWNER
, D.NAME DIMENSION_NAME
, DAT.PHYSICALNAME DIM_ATTRIBUTE_NAME
, LVL.PHYSICALNAME LEVEL_NAME
, LAT.NAME LVL_ATTRIBUTE_NAME FROM DBA_USERS U
, SYS.OBJ$ D
, CWM$DIMENSIONATTRIBUTE DAT
, CWM$ITEMUSE USE1
, CWM$ITEMUSE USE2
, CWM$LEVELATTRIBUTE LAT
, CWM$LEVEL LVL
, SYS.DIMLEVEL$ L
, SYS.DIMATTR$ A
, SYS.COL$ C WHERE U.USER_ID = D.OWNER# AND D.TYPE# = 43 /* DIMENSION */ AND ( CWM$UTIL.DIMENSION_TABLES_VISIBLE(D.OBJ#) = 'Y' OR EXISTS /* SELECT ANY TABLE
, CREATE
, ALTER
, DROP ANY DIMENSION */ (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-47
, -215
, -216
, -217))) AND D.OBJ# = DAT.ITEMCONTAINER_IRID AND DAT.IRID = USE1.MAPPABLE_IRID AND USE1.OPERATION_IRID = USE2.OPERATION_IRID_1 AND USE2.MAPPABLE_IRID = LAT.IRID AND LAT.ITEMCONTAINER_IRID = LVL.IRID AND LVL.DIMENSION_IRID = L.DIMOBJ# AND L.DIMOBJ# = A.DIMOBJ# AND L.LEVELID# = A.LEVELID# AND A.DETAILOBJ# = C.OBJ# AND A.COL# = C.COL# AND LVL.PHYSICALNAME = L.LEVELNAME AND LAT.TYPE_IRID = C.OBJ# AND LAT.PHYSICALNAME = C.NAME WITH READ ONLY