VIEW: OLAPSYS.DBA$OLAP2_DIM_ATTRIBUTES

Source

View Text - Preformatted

select
  d.owner owner,
  d.name dimension_name,
  da.name attribute_name,
  da.displayname display_name,
  da.shortdescription short_description,
  da.description description,
  ce.classification_irid desc_id
from olapsys.CwM2$dimension d,
     olapsys.CwM2$dimensionattribute da,
     olapsys.cwm$classificationentry ce
where da.dimension_irid = d.irid and
      da.irid = ce.element_irid (+) and
      ce.name (+) = 'DIMENSION ATTRIBUTE2'
with read only

View Text - HTML Formatted

SELECT D.OWNER OWNER
, D.NAME DIMENSION_NAME
, DA.NAME ATTRIBUTE_NAME
, DA.DISPLAYNAME DISPLAY_NAME
, DA.SHORTDESCRIPTION SHORT_DESCRIPTION
, DA.DESCRIPTION DESCRIPTION
, CE.CLASSIFICATION_IRID DESC_ID FROM OLAPSYS.CWM2$DIMENSION D
, OLAPSYS.CWM2$DIMENSIONATTRIBUTE DA
, OLAPSYS.CWM$CLASSIFICATIONENTRY CE WHERE DA.DIMENSION_IRID = D.IRID AND DA.IRID = CE.ELEMENT_IRID (+) AND CE.NAME (+) = 'DIMENSION ATTRIBUTE2' WITH READ ONLY