VIEW: OLAPSYS.DBA$OLAP2_DIM_LEVEL_ATTRIBUTES

Source

View Text - Preformatted

select
  d.owner owner,
  d.name dimension_name,
  la.name attribute_name,
  la.displayname display_name,
  la.shortdescription short_description,
  la.description description,
  l.name determined_by_level_name
from olapsys.CwM2$dimension d,
     olapsys.CwM2$levelattribute la,
     olapsys.CwM2$Level l
where d.irid = la.dimension_irid and
      la.level_irid = l.irid and
      l.dimension_irid = d.irid
with read only

View Text - HTML Formatted

SELECT D.OWNER OWNER
, D.NAME DIMENSION_NAME
, LA.NAME ATTRIBUTE_NAME
, LA.DISPLAYNAME DISPLAY_NAME
, LA.SHORTDESCRIPTION SHORT_DESCRIPTION
, LA.DESCRIPTION DESCRIPTION
, L.NAME DETERMINED_BY_LEVEL_NAME FROM OLAPSYS.CWM2$DIMENSION D
, OLAPSYS.CWM2$LEVELATTRIBUTE LA
, OLAPSYS.CWM2$LEVEL L WHERE D.IRID = LA.DIMENSION_IRID AND LA.LEVEL_IRID = L.IRID AND L.DIMENSION_IRID = D.IRID WITH READ ONLY