VIEW: OLAPSYS.DBA$OLAP2_DIM_LEVELS

Source

View Text - Preformatted

select
  d.owner owner,
  d.name dimension_name,
  l.name level_name,
  l.displayname display_name,
  l.shortdescription short_description,
  l.description description
from olapsys.CwM2$dimension d,
     olapsys.CwM2$level l
where d.irid = l.dimension_irid
with read only

View Text - HTML Formatted

SELECT D.OWNER OWNER
, D.NAME DIMENSION_NAME
, L.NAME LEVEL_NAME
, L.DISPLAYNAME DISPLAY_NAME
, L.SHORTDESCRIPTION SHORT_DESCRIPTION
, L.DESCRIPTION DESCRIPTION FROM OLAPSYS.CWM2$DIMENSION D
, OLAPSYS.CWM2$LEVEL L WHERE D.IRID = L.DIMENSION_IRID WITH READ ONLY