select
ftfm.owner owner,
ftfm.cube_name cube_name,
ftfm.measure_name measure_name,
ftfm.fact_table_owner fact_table_owner,
ftfm.fact_table_name fact_table_name,
ftfm.column_name column_name,
ftfm.data_type data_type,
ftfm.data_length data_length,
ftfm.data_precision data_precision,
ftfm.olap_api_data_type olap_api_data_type
from olapsys.cwm2$mrfacttblfctmaps ftfm,
olapsys.olap_session_objects oso
where oso.version_id = ftfm.version_id and
oso.id = ftfm.id
SELECT
FTFM.OWNER OWNER
,
FTFM.CUBE_NAME CUBE_NAME
,
FTFM.MEASURE_NAME MEASURE_NAME
,
FTFM.FACT_TABLE_OWNER FACT_TABLE_OWNER
,
FTFM.FACT_TABLE_NAME FACT_TABLE_NAME
,
FTFM.COLUMN_NAME COLUMN_NAME
,
FTFM.DATA_TYPE DATA_TYPE
,
FTFM.DATA_LENGTH DATA_LENGTH
,
FTFM.DATA_PRECISION DATA_PRECISION
,
FTFM.OLAP_API_DATA_TYPE OLAP_API_DATA_TYPE
FROM OLAPSYS.CWM2$MRFACTTBLFCTMAPS FTFM
,
OLAPSYS.OLAP_SESSION_OBJECTS OSO
WHERE OSO.VERSION_ID = FTFM.VERSION_ID AND
OSO.ID = FTFM.ID
|
|
|