VIEW: OLAPSYS.ALL$OLAP1_CUBES

Source

View Text - Preformatted

SELECT DISTINCT
   sch.physicalname owner
   , cub.physicalname cube_name
   , cwm$util.cube_invalid(cub.irid) invalid
   , cub.displayname display_name
   , cub.description short_description
   , cub.description description
   , nvl(cub.mvsummarycode, 'RU') mv_summarycode
FROM
   dba_users u
  , cwm$model sch
  , cwm$cube  cub
  , cwm$cubedimensionuse cdu
  , cwm$dimension cd
  , dba_users du
  , sys.obj$ do
WHERE u.username = sch.physicalname
    AND sch.irid = cub.datamodel_irid
    AND cdu.cube_irid = cub.irid
    AND cdu.dimension_owner = du.username
    AND cdu.dimension_name = do.name
    AND do.type# = 43
    AND du.user_id = do.owner#
    AND do.obj# = cd.irid
    AND cd.irid = cdu.ABSTRACTDIMENSION_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 DISTINCT SCH.PHYSICALNAME OWNER
, CUB.PHYSICALNAME CUBE_NAME
, CWM$UTIL.CUBE_INVALID(CUB.IRID) INVALID
, CUB.DISPLAYNAME DISPLAY_NAME
, CUB.DESCRIPTION SHORT_DESCRIPTION
, CUB.DESCRIPTION DESCRIPTION
, NVL(CUB.MVSUMMARYCODE
, 'RU') MV_SUMMARYCODE FROM DBA_USERS U
, CWM$MODEL SCH
, CWM$CUBE CUB
, CWM$CUBEDIMENSIONUSE CDU
, CWM$DIMENSION CD
, DBA_USERS DU
, SYS.OBJ$ DO WHERE U.USERNAME = SCH.PHYSICALNAME
AND SCH.IRID = CUB.DATAMODEL_IRID
AND CDU.CUBE_IRID = CUB.IRID
AND CDU.DIMENSION_OWNER = DU.USERNAME
AND CDU.DIMENSION_NAME = DO.NAME
AND DO.TYPE# = 43
AND DU.USER_ID = DO.OWNER#
AND DO.OBJ# = CD.IRID
AND CD.IRID = CDU.ABSTRACTDIMENSION_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