select
dhlu.owner owner,
dhlu.dimension_name dimension_name,
dhlu.hierarchy_name hierarchy_name,
dhlu.parent_level_name parent_level_name,
dhlu.child_level_name child_level_name,
dhlu.position position
from olapsys.cwm2$mrall_dim_hier_level_uses dhlu,
olapsys.olap_session_objects oso
where oso.version_id = dhlu.version_id and
oso.id = dhlu.id
SELECT
DHLU.OWNER OWNER
,
DHLU.DIMENSION_NAME DIMENSION_NAME
,
DHLU.HIERARCHY_NAME HIERARCHY_NAME
,
DHLU.PARENT_LEVEL_NAME PARENT_LEVEL_NAME
,
DHLU.CHILD_LEVEL_NAME CHILD_LEVEL_NAME
,
DHLU.POSITION POSITION
FROM OLAPSYS.CWM2$MRALL_DIM_HIER_LEVEL_USES DHLU
,
OLAPSYS.OLAP_SESSION_OBJECTS OSO
WHERE OSO.VERSION_ID = DHLU.VERSION_ID AND
OSO.ID = DHLU.ID
|
|
|