select
d.owner owner,
d.name dimension_name,
(case when h.hidden = 'N'
then h.name else null end) 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 d.irid = pl.dimension_irid and
d.irid = cl.dimension_irid and
h.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
SELECT
D.OWNER OWNER
,
D.NAME DIMENSION_NAME
,
(CASE WHEN H.HIDDEN = 'N'
THEN H.NAME ELSE NULL END) 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 D.IRID = PL.DIMENSION_IRID AND
D.IRID = CL.DIMENSION_IRID AND
H.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
|
|
|