VIEW: OLAPSYS.DBA$OLAP_DIM_ATTRIBUTES

Source

View Text - Preformatted

SELECT
  u.username owner
, d.name dimension_name
, att.physicalname attribute_name
, att.displayname display_name
, att.description description
FROM
  dba_users u
, sys.obj$ d
, cwm$dimensionattribute att
WHERE d.type# = 43 /* DIMENSION */
AND u.user_id = d.owner#
AND d.obj# = att.itemcontainer_irid
WITH READ ONLY

View Text - HTML Formatted

SELECT U.USERNAME OWNER
, D.NAME DIMENSION_NAME
, ATT.PHYSICALNAME ATTRIBUTE_NAME
, ATT.DISPLAYNAME DISPLAY_NAME
, ATT.DESCRIPTION DESCRIPTION FROM DBA_USERS U
, SYS.OBJ$ D
, CWM$DIMENSIONATTRIBUTE ATT WHERE D.TYPE# = 43 /* DIMENSION */ AND U.USER_ID = D.OWNER# AND D.OBJ# = ATT.ITEMCONTAINER_IRID WITH READ ONLY