select
hkm.owner owner,
hkm.dimension_name dimension_name,
hkm.hierarchy_name hierarchy_name,
hkm.level_name level_name,
hkm.display_name display_name,
hkm.shortdescription short_description,
hkm.description description,
hkm.hierarchy_position hierarchy_position,
hkm.table_owner table_owner,
hkm.table_name table_name,
hkm.column_name column_name,
hkm.column_position column_position,
hkm.data_type data_type,
hkm.data_length data_length,
hkm.data_precision data_precision
from olapsys.cwm2$mrall_hierdim_keycol_map hkm,
olapsys.olap_session_objects oso
where oso.version_id = hkm.version_id and
oso.id = hkm.id
SELECT
HKM.OWNER OWNER
,
HKM.DIMENSION_NAME DIMENSION_NAME
,
HKM.HIERARCHY_NAME HIERARCHY_NAME
,
HKM.LEVEL_NAME LEVEL_NAME
,
HKM.DISPLAY_NAME DISPLAY_NAME
,
HKM.SHORTDESCRIPTION SHORT_DESCRIPTION
,
HKM.DESCRIPTION DESCRIPTION
,
HKM.HIERARCHY_POSITION HIERARCHY_POSITION
,
HKM.TABLE_OWNER TABLE_OWNER
,
HKM.TABLE_NAME TABLE_NAME
,
HKM.COLUMN_NAME COLUMN_NAME
,
HKM.COLUMN_POSITION COLUMN_POSITION
,
HKM.DATA_TYPE DATA_TYPE
,
HKM.DATA_LENGTH DATA_LENGTH
,
HKM.DATA_PRECISION DATA_PRECISION
FROM OLAPSYS.CWM2$MRALL_HIERDIM_KEYCOL_MAP HKM
,
OLAPSYS.OLAP_SESSION_OBJECTS OSO
WHERE OSO.VERSION_ID = HKM.VERSION_ID AND
OSO.ID = HKM.ID
|
|
|