eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: OLAPSYS.MRV$OLAP2_FACTTBLFCTMAPS

Source

View Text - Preformatted


select
  ftfm.owner owner,
  ftfm.cube_name cube_name,
  ftfm.measure_name measure_name,
  ftfm.dim_hier_combo_id dim_hier_combo_id,
  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$mrall_facttblfctmaps ftfm,
      olapsys.olap_session_objects oso
 where oso.version_id = ftfm.version_id and
       oso.id = ftfm.id

View Text - HTML Formatted

SELECT FTFM.OWNER OWNER
, FTFM.CUBE_NAME CUBE_NAME
, FTFM.MEASURE_NAME MEASURE_NAME
, FTFM.DIM_HIER_COMBO_ID DIM_HIER_COMBO_ID
, 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$MRALL_FACTTBLFCTMAPS FTFM
, OLAPSYS.OLAP_SESSION_OBJECTS OSO
WHERE OSO.VERSION_ID = FTFM.VERSION_ID AND OSO.ID = FTFM.ID