VIEW: OLAPSYS.ALL$OLAPMR_DIMENSIONS

Source

View Text - Preformatted

SELECT
  u.username                  owner,
  o.name                  dimension_name,
  dim.pluralname          plural_name,
  dim.displayname         display_name,
  dim.description         short_description,
  dim.description         description,
  display_hierarchy_name  default_display_hierarchy,
  o.status                status
FROM
  sys.dim$                d,
  dba_users               u,
  sys.obj$                o,
  cwm$dimension           dim
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)))
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 SHORT_DESCRIPTION
, DIM.DESCRIPTION DESCRIPTION
, DISPLAY_HIERARCHY_NAME DEFAULT_DISPLAY_HIERARCHY
, O.STATUS STATUS FROM SYS.DIM$ D
, DBA_USERS U
, SYS.OBJ$ O
, CWM$DIMENSION DIM 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))) WITH READ ONLY