select
hd.owner owner,
hd.dimension_name dimension_name,
hd.plural_name plural_name,
hd.display_name display_name,
hd.shortdescription short_description,
hd.description description,
hd.default_display_hierarchy default_display_hierarchy,
hd.descriptor_value descriptor_value
from olapsys.cwm2$mrall_hierdims hd,
olapsys.olap_session_objects oso
where oso.version_id = hd.version_id and
oso.id = hd.id
SELECT
HD.OWNER OWNER
,
HD.DIMENSION_NAME DIMENSION_NAME
,
HD.PLURAL_NAME PLURAL_NAME
,
HD.DISPLAY_NAME DISPLAY_NAME
,
HD.SHORTDESCRIPTION SHORT_DESCRIPTION
,
HD.DESCRIPTION DESCRIPTION
,
HD.DEFAULT_DISPLAY_HIERARCHY DEFAULT_DISPLAY_HIERARCHY
,
HD.DESCRIPTOR_VALUE DESCRIPTOR_VALUE
FROM OLAPSYS.CWM2$MRALL_HIERDIMS HD
,
OLAPSYS.OLAP_SESSION_OBJECTS OSO
WHERE OSO.VERSION_ID = HD.VERSION_ID AND
OSO.ID = HD.ID
|
|
|