select owner owner,
dimension_name dimension_name,
hierarchy_name hierarchy_name,
level_name level_name,
display_name display_name,
short_description short_description,
description description,
pos hierarchy_position,
table_owner table_owner,
table_name table_name,
column_name column_name,
column_position column_position,
data_type data_type,
data_length data_length,
data_precision data_precision
from olapsys.dba$olap2_dim_levels_keymaps
union all
select owner owner,
dimension_name dimension_name,
hierarchy_name hierarchy_name,
level_name level_name,
display_name display_name,
short_description short_description,
description description,
pos hierarchy_position,
table_owner table_owner,
table_name table_name,
column_name column_name,
column_position column_position,
data_type data_type,
data_length data_length,
data_precision data_precision
from olapsys.dba$olapmr_dim_levels_keymaps
with read only
SELECT OWNER OWNER
,
DIMENSION_NAME DIMENSION_NAME
,
HIERARCHY_NAME HIERARCHY_NAME
,
LEVEL_NAME LEVEL_NAME
,
DISPLAY_NAME DISPLAY_NAME
,
SHORT_DESCRIPTION SHORT_DESCRIPTION
,
DESCRIPTION DESCRIPTION
,
POS HIERARCHY_POSITION
,
TABLE_OWNER TABLE_OWNER
,
TABLE_NAME TABLE_NAME
,
COLUMN_NAME COLUMN_NAME
,
COLUMN_POSITION COLUMN_POSITION
,
DATA_TYPE DATA_TYPE
,
DATA_LENGTH DATA_LENGTH
,
DATA_PRECISION DATA_PRECISION
FROM OLAPSYS.DBA$OLAP2_DIM_LEVELS_KEYMAPS
UNION ALL
SELECT OWNER OWNER
,
DIMENSION_NAME DIMENSION_NAME
,
HIERARCHY_NAME HIERARCHY_NAME
,
LEVEL_NAME LEVEL_NAME
,
DISPLAY_NAME DISPLAY_NAME
,
SHORT_DESCRIPTION SHORT_DESCRIPTION
,
DESCRIPTION DESCRIPTION
,
POS HIERARCHY_POSITION
,
TABLE_OWNER TABLE_OWNER
,
TABLE_NAME TABLE_NAME
,
COLUMN_NAME COLUMN_NAME
,
COLUMN_POSITION COLUMN_POSITION
,
DATA_TYPE DATA_TYPE
,
DATA_LENGTH DATA_LENGTH
,
DATA_PRECISION DATA_PRECISION
FROM OLAPSYS.DBA$OLAPMR_DIM_LEVELS_KEYMAPS
WITH READ ONLY
|
|
|