VIEW: OLAPSYS.ALL$OLAP_DIMENSIONS

Source

View Text - Preformatted

SELECT
  u.username owner
, o.name dimension_name
, dim.pluralname plural_name
, dim.displayname display_name
, dim.description description
, display_hierarchy_name default_display_hierarchy
, decode(o.status, 5, 'Y', 'N') invalid
, cwm$util.dim_valid(o.obj#) olap_valid
FROM
  dba_users u
, sys.obj$ o
, sys.dim$ d
, cwm$dimension dim
WHERE 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)))
WITH READ ONLY

View Text - HTML Formatted

SELECT U.USERNAME OWNER
, O.NAME DIMENSION_NAME
, DIM.PLURALNAME PLURAL_NAME
, DIM.DISPLAYNAME DISPLAY_NAME
, DIM.DESCRIPTION DESCRIPTION
, DISPLAY_HIERARCHY_NAME DEFAULT_DISPLAY_HIERARCHY
, DECODE(O.STATUS
, 5
, 'Y'
, 'N') INVALID
, CWM$UTIL.DIM_VALID(O.OBJ#) OLAP_VALID FROM DBA_USERS U
, SYS.OBJ$ O
, SYS.DIM$ D
, CWM$DIMENSION DIM WHERE 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))) WITH READ ONLY