VIEW: OLAPSYS.ALL$AW_LOAD_DIM_MAP

Source

View Text - Preformatted

select
  d.owner  OWNER,
  d.name  DIMENSION_NAME,
  l.name  LOAD_NAME,
  d.irid  DIM_IRID,
  l.irid  LOAD_IRID,
  l.version_id VERSION_ID
 from
   olapsys.cwm2$dimension d,
   olapsys.cwm2$awdimload l
 where
   d.irid = l.dim_irid and
   l.version_id = 'CWM2' and
   d.invalid = 'N' and
   (cwm2$security.dimension_tables_visible(d.irid) = 'Y'
       OR EXISTS (select null from v$enabledprivs
                  where priv_number in (-47, -215, -216, -217)))
union all
SELECT
  u.username  owner,
  o.name  dimension_name,
  l.name  LOAD_NAME,
  dim.irid DIM_IRID,
  l.irid LOAD_IRID,
  l.version_id VERSION_ID
FROM
  sys.dim$                d,
  dba_users               u,
  sys.obj$                o,
  cwm$dimension           dim,
   olapsys.cwm2$awdimload l
WHERE o.type# = 43 AND
      u.user_id = o.owner# AND
      o.obj#  = d.obj# AND
      d.obj#  = dim.irid 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
        dim.irid = l.dim_irid and
        l.version_id = 'CWM'
with read only

View Text - HTML Formatted

SELECT D.OWNER OWNER
, D.NAME DIMENSION_NAME
, L.NAME LOAD_NAME
, D.IRID DIM_IRID
, L.IRID LOAD_IRID
, L.VERSION_ID VERSION_ID FROM OLAPSYS.CWM2$DIMENSION D
, OLAPSYS.CWM2$AWDIMLOAD L WHERE D.IRID = L.DIM_IRID AND L.VERSION_ID = 'CWM2' AND D.INVALID = 'N' AND (CWM2$SECURITY.DIMENSION_TABLES_VISIBLE(D.IRID) = 'Y' OR EXISTS (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-47
, -215
, -216
, -217))) UNION ALL SELECT U.USERNAME OWNER
, O.NAME DIMENSION_NAME
, L.NAME LOAD_NAME
, DIM.IRID DIM_IRID
, L.IRID LOAD_IRID
, L.VERSION_ID VERSION_ID FROM SYS.DIM$ D
, DBA_USERS U
, SYS.OBJ$ O
, CWM$DIMENSION DIM
, OLAPSYS.CWM2$AWDIMLOAD L WHERE O.TYPE# = 43 AND U.USER_ID = O.OWNER# AND O.OBJ# = D.OBJ# AND D.OBJ# = DIM.IRID 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 DIM.IRID = L.DIM_IRID AND L.VERSION_ID = 'CWM' WITH READ ONLY