select
dh.owner owner,
dh.dimension_name dimension_name,
dh.hierarchy_name hierarchy_name,
dh.display_name display_name,
dh.shortdescription short_description,
dh.description description,
dh.solved_code solved_code,
dh.is_default is_default
from olapsys.cwm2$mrall_dim_hiers dh,
olapsys.olap_session_objects oso
where oso.version_id = dh.version_id and
oso.id = dh.id
SELECT
DH.OWNER OWNER
,
DH.DIMENSION_NAME DIMENSION_NAME
,
DH.HIERARCHY_NAME HIERARCHY_NAME
,
DH.DISPLAY_NAME DISPLAY_NAME
,
DH.SHORTDESCRIPTION SHORT_DESCRIPTION
,
DH.DESCRIPTION DESCRIPTION
,
DH.SOLVED_CODE SOLVED_CODE
,
DH.IS_DEFAULT IS_DEFAULT
FROM OLAPSYS.CWM2$MRALL_DIM_HIERS DH
,
OLAPSYS.OLAP_SESSION_OBJECTS OSO
WHERE OSO.VERSION_ID = DH.VERSION_ID AND
OSO.ID = DH.ID
|
|
|