select
hcs.owner owner,
hcs.dimension_name dimension_name,
hcs.hierarchy_name hierarchy_name,
hcs.table_owner table_owner,
hcs.table_name table_name,
hcs.column_name column_name,
hcs.position position,
hcs.sort_pos sort_pos,
hcs.sort_order sort_order,
hcs.null_order null_order,
hcs.data_type data_type,
hcs.data_length data_length,
hcs.data_precision data_precision
from olapsys.cwm2$mrall_hier_custom_sort hcs,
olapsys.olap_session_objects oso
where oso.version_id = hcs.version_id and
oso.id = hcs.id
SELECT
HCS.OWNER OWNER
,
HCS.DIMENSION_NAME DIMENSION_NAME
,
HCS.HIERARCHY_NAME HIERARCHY_NAME
,
HCS.TABLE_OWNER TABLE_OWNER
,
HCS.TABLE_NAME TABLE_NAME
,
HCS.COLUMN_NAME COLUMN_NAME
,
HCS.POSITION POSITION
,
HCS.SORT_POS SORT_POS
,
HCS.SORT_ORDER SORT_ORDER
,
HCS.NULL_ORDER NULL_ORDER
,
HCS.DATA_TYPE DATA_TYPE
,
HCS.DATA_LENGTH DATA_LENGTH
,
HCS.DATA_PRECISION DATA_PRECISION
FROM OLAPSYS.CWM2$MRALL_HIER_CUSTOM_SORT HCS
,
OLAPSYS.OLAP_SESSION_OBJECTS OSO
WHERE OSO.VERSION_ID = HCS.VERSION_ID AND
OSO.ID = HCS.ID
|
|
|