VIEW: OLAPSYS.ALL$OLAP_CUBES

Source

View Text - Preformatted

SELECT
  sch.physicalname owner
, cub.physicalname cube_name
, cwm$util.cube_invalid(cub.irid) invalid
, cub.displayname display_name
, cub.description description
FROM
  dba_users u
, cwm$model sch
, cwm$cube  cub
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))
WITH READ ONLY

View Text - HTML Formatted

SELECT SCH.PHYSICALNAME OWNER
, CUB.PHYSICALNAME CUBE_NAME
, CWM$UTIL.CUBE_INVALID(CUB.IRID) INVALID
, CUB.DISPLAYNAME DISPLAY_NAME
, CUB.DESCRIPTION DESCRIPTION FROM DBA_USERS U
, CWM$MODEL SCH
, CWM$CUBE CUB 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)) WITH READ ONLY