VIEW: OLAPSYS.ALL$AW_LOAD_CUBE_MAP

Source

View Text - Preformatted

select
   c.owner owner,
   c.name cube_name,
   c.irid cube_irid,
   l.name load_name,
   l.irid load_irid,
   l.version_id version_id
  from olapsys.CwM2$Cube c,
       olapsys.cwm2$awcubeload l
    where (c.invalid = 'N' OR c.invalid = 'O') and
    l.version_id = 'CWM2' and
    (cwm2$security.fact_table_visible(c.irid) = 'Y'
       OR EXISTS (select null from v$enabledprivs
                  where priv_number in (-47)))
    and
      c.irid = l.cube_irid
union all
SELECT
   sch.physicalname owner
   , cub.physicalname cube_name
   , cub.irid cube_irid,
   l.name load_name,
   l.irid load_irid,
   l.version_id version_id
FROM
   dba_users u
  , cwm$model sch
  , cwm$cube  cub
  , olapsys.cwm2$awcubeload l
WHERE u.username = sch.physicalname
    AND sch.irid = cub.datamodel_irid
    AND (cwm$util.fact_table_visible(cub.irid) = 'Y'
         OR EXISTS /* SELECT ANY TABLE */
          (SELECT null FROM v$enabledprivs
            WHERE priv_number = -47))
   and cub.irid = l.cube_irid and
       l.version_id = 'CWM'
with read only

View Text - HTML Formatted

SELECT C.OWNER OWNER
, C.NAME CUBE_NAME
, C.IRID CUBE_IRID
, L.NAME LOAD_NAME
, L.IRID LOAD_IRID
, L.VERSION_ID VERSION_ID
FROM OLAPSYS.CWM2$CUBE C
, OLAPSYS.CWM2$AWCUBELOAD L
WHERE (C.INVALID = 'N' OR C.INVALID = 'O') AND L.VERSION_ID = 'CWM2' AND (CWM2$SECURITY.FACT_TABLE_VISIBLE(C.IRID) = 'Y' OR EXISTS (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-47))) AND C.IRID = L.CUBE_IRID UNION ALL SELECT SCH.PHYSICALNAME OWNER
, CUB.PHYSICALNAME CUBE_NAME
, CUB.IRID CUBE_IRID
, L.NAME LOAD_NAME
, L.IRID LOAD_IRID
, L.VERSION_ID VERSION_ID FROM DBA_USERS U
, CWM$MODEL SCH
, CWM$CUBE CUB
, OLAPSYS.CWM2$AWCUBELOAD L WHERE U.USERNAME = SCH.PHYSICALNAME
AND SCH.IRID = CUB.DATAMODEL_IRID
AND (CWM$UTIL.FACT_TABLE_VISIBLE(CUB.IRID) = 'Y' OR EXISTS /* SELECT ANY TABLE */ (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER = -47))
AND CUB.IRID = L.CUBE_IRID AND L.VERSION_ID = 'CWM' WITH READ ONLY