VIEW: OLAPSYS.ALL$OLAPMR_FACTTBLFCTMAPS

Source

View Text - Preformatted

select a.owner owner,
       a.cube_name cube_name,
       a.measure_name measure_name,
       a.fact_table_owner fact_table_owner,
       a.fact_table_name fact_table_name,
       a.column_name column_name,
       c.data_type data_type,
       c.data_length data_length,
       c.data_precision data_precision,
       (case when c.data_type = 'NUMBER' then 0
              when c.data_type = 'DOUBLE' then 5
              when c.data_type = 'FLOAT' then 4
              when c.data_type = 'DATE' then 7
              when c.data_type = 'LONG' then 3
              else 1 end) olap_api_data_type
from olapsys.all$olap2ucube_measure_maps a,
     all_olap_columns c
where a.dim_hier_combo_id = 0
 and a.fact_table_owner = c.owner
 and a.fact_table_name = c.table_name
 and a.column_name = c.column_name
with read only

View Text - HTML Formatted

SELECT A.OWNER OWNER
, A.CUBE_NAME CUBE_NAME
, A.MEASURE_NAME MEASURE_NAME
, A.FACT_TABLE_OWNER FACT_TABLE_OWNER
, A.FACT_TABLE_NAME FACT_TABLE_NAME
, A.COLUMN_NAME COLUMN_NAME
, C.DATA_TYPE DATA_TYPE
, C.DATA_LENGTH DATA_LENGTH
, C.DATA_PRECISION DATA_PRECISION
, (CASE WHEN C.DATA_TYPE = 'NUMBER' THEN 0 WHEN C.DATA_TYPE = 'DOUBLE' THEN 5 WHEN C.DATA_TYPE = 'FLOAT' THEN 4 WHEN C.DATA_TYPE = 'DATE' THEN 7 WHEN C.DATA_TYPE = 'LONG' THEN 3 ELSE 1 END) OLAP_API_DATA_TYPE FROM OLAPSYS.ALL$OLAP2UCUBE_MEASURE_MAPS A
, ALL_OLAP_COLUMNS C WHERE A.DIM_HIER_COMBO_ID = 0
AND A.FACT_TABLE_OWNER = C.OWNER
AND A.FACT_TABLE_NAME = C.TABLE_NAME
AND A.COLUMN_NAME = C.COLUMN_NAME WITH READ ONLY