VIEW: OLAPSYS.EXPORT2_DIM_HIER_LEVEL_USES

Source

View Text - Preformatted

select
  d.owner owner,
  d.name dimension_name,
--  (case when h.hidden = 'Y'
--        then null else h.name end) hierarchy_name,
  h.name hierarchy_name,
  pl.name parent_level_name,
  cl.name child_level_name,
  hlr.leveldepth position
from olapsys.CwM2$dimension d,
     olapsys.CwM2$level pl,
     olapsys.CwM2$level cl,
     olapsys.CwM2$HierLevelRel hlr,
     olapsys.CwM2$Hierarchy h
where hlr.dimension_irid = d.irid and
      hlr.hierarchy_IRID = h.irid and
      hlr.parentlevel_irid = pl.irid(+) and
      hlr.childlevel_irid = cl.irid
with read only

View Text - HTML Formatted

SELECT D.OWNER OWNER
, D.NAME DIMENSION_NAME
, -- (CASE WHEN H.HIDDEN = 'Y' -- THEN NULL ELSE H.NAME END) HIERARCHY_NAME
, H.NAME HIERARCHY_NAME
, PL.NAME PARENT_LEVEL_NAME
, CL.NAME CHILD_LEVEL_NAME
, HLR.LEVELDEPTH POSITION FROM OLAPSYS.CWM2$DIMENSION D
, OLAPSYS.CWM2$LEVEL PL
, OLAPSYS.CWM2$LEVEL CL
, OLAPSYS.CWM2$HIERLEVELREL HLR
, OLAPSYS.CWM2$HIERARCHY H WHERE HLR.DIMENSION_IRID = D.IRID AND HLR.HIERARCHY_IRID = H.IRID AND HLR.PARENTLEVEL_IRID = PL.IRID(+) AND HLR.CHILDLEVEL_IRID = CL.IRID WITH READ ONLY