VIEW: OLAPSYS.MRV$OLAP2_DIM_ATTRIBUTES

Source

View Text - Preformatted

select
  da.owner owner,
  da.dimension_name dimension_name,
  da.attribute_name attribute_name,
  da.display_name display_name,
  da.shortdescription short_description,
  da.description description,
  da.desc_id desc_id
 from olapsys.cwm2$mrall_dim_attributes da,
      olapsys.olap_session_objects oso
 where oso.version_id = da.version_id and
       oso.id = da.id

View Text - HTML Formatted

SELECT DA.OWNER OWNER
, DA.DIMENSION_NAME DIMENSION_NAME
, DA.ATTRIBUTE_NAME ATTRIBUTE_NAME
, DA.DISPLAY_NAME DISPLAY_NAME
, DA.SHORTDESCRIPTION SHORT_DESCRIPTION
, DA.DESCRIPTION DESCRIPTION
, DA.DESC_ID DESC_ID
FROM OLAPSYS.CWM2$MRALL_DIM_ATTRIBUTES DA
, OLAPSYS.OLAP_SESSION_OBJECTS OSO
WHERE OSO.VERSION_ID = DA.VERSION_ID AND OSO.ID = DA.ID