VIEW: OLAPSYS.ALL$OLAPMR_DIM_ATTRIBUTES

Source

View Text - Preformatted

SELECT
  u.username                  owner,
  o.name                  dimension_name,
  att.physicalname        attribute_name,
  att.displayname         display_name,
  att.description         short_description,
  att.description         description,
  ce.classification_irid  desc_id
FROM
  dba_users               u,
  sys.obj$                o,
  cwm$dimensionattribute  att,
  cwm$classificationentry ce
WHERE o.type# = 43 AND
      u.user_id = o.owner# AND
      att.itemcontainer_irid = o.obj# AND
      att.irid = ce.element_irid(+) AND
      ce.name (+) = 'DIMENSION ATTRIBUTE' AND
      (   cwm$util.dimension_tables_visible(o.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
, ATT.PHYSICALNAME ATTRIBUTE_NAME
, ATT.DISPLAYNAME DISPLAY_NAME
, ATT.DESCRIPTION SHORT_DESCRIPTION
, ATT.DESCRIPTION DESCRIPTION
, CE.CLASSIFICATION_IRID DESC_ID FROM DBA_USERS U
, SYS.OBJ$ O
, CWM$DIMENSIONATTRIBUTE ATT
, CWM$CLASSIFICATIONENTRY CE WHERE O.TYPE# = 43 AND U.USER_ID = O.OWNER# AND ATT.ITEMCONTAINER_IRID = O.OBJ# AND ATT.IRID = CE.ELEMENT_IRID(+) AND CE.NAME (+) = 'DIMENSION ATTRIBUTE' AND ( CWM$UTIL.DIMENSION_TABLES_VISIBLE(O.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