VIEW: OLAPSYS.DBA$OLAP2_DIM_ATTR_USES

Source

View Text - Preformatted

select
  d.owner owner,
  d.name dimension_name,
  da.name dim_attribute_name,
  l.name level_name,
  la.name lvl_attribute_name
from olapsys.CwM2$dimension d,
     olapsys.CwM2$dimensionattribute da,
     olapsys.CwM2$levelattribute la,
     olapsys.CwM2$level l
where da.dimension_irid = d.irid and
      la.dimattr_irid = da.irid and
      la.level_irid = l.irid
with read only

View Text - HTML Formatted

SELECT D.OWNER OWNER
, D.NAME DIMENSION_NAME
, DA.NAME DIM_ATTRIBUTE_NAME
, L.NAME LEVEL_NAME
, LA.NAME LVL_ATTRIBUTE_NAME FROM OLAPSYS.CWM2$DIMENSION D
, OLAPSYS.CWM2$DIMENSIONATTRIBUTE DA
, OLAPSYS.CWM2$LEVELATTRIBUTE LA
, OLAPSYS.CWM2$LEVEL L WHERE DA.DIMENSION_IRID = D.IRID AND LA.DIMATTR_IRID = DA.IRID AND LA.LEVEL_IRID = L.IRID WITH READ ONLY