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$OLAP1_FACTTBLKEYMAPS

Source

View Text - Preformatted


select
  ftkm.owner owner,
  ftkm.cube_name cube_name,
  ftkm.dimension_owner dimension_owner,
  ftkm.dimension_name dimension_name,
  ftkm.level_name level_name,
  ftkm.fact_table_owner fact_table_owner,
  ftkm.fact_table_name fact_table_name,
  ftkm.column_name column_name,
  ftkm.column_position column_position,
  ftkm.mv_summary_code mv_summary_code,
  ftkm.data_type data_type,
  ftkm.data_length data_length,
  ftkm.data_precision data_precision
 from olapsys.cwm2$mrfacttblkeymaps ftkm,
      olapsys.olap_session_objects oso
 where oso.version_id = ftkm.version_id and
       oso.id = ftkm.id

View Text - HTML Formatted

SELECT FTKM.OWNER OWNER
, FTKM.CUBE_NAME CUBE_NAME
, FTKM.DIMENSION_OWNER DIMENSION_OWNER
, FTKM.DIMENSION_NAME DIMENSION_NAME
, FTKM.LEVEL_NAME LEVEL_NAME
, FTKM.FACT_TABLE_OWNER FACT_TABLE_OWNER
, FTKM.FACT_TABLE_NAME FACT_TABLE_NAME
, FTKM.COLUMN_NAME COLUMN_NAME
, FTKM.COLUMN_POSITION COLUMN_POSITION
, FTKM.MV_SUMMARY_CODE MV_SUMMARY_CODE
, FTKM.DATA_TYPE DATA_TYPE
, FTKM.DATA_LENGTH DATA_LENGTH
, FTKM.DATA_PRECISION DATA_PRECISION
FROM OLAPSYS.CWM2$MRFACTTBLKEYMAPS FTKM
, OLAPSYS.OLAP_SESSION_OBJECTS OSO
WHERE OSO.VERSION_ID = FTKM.VERSION_ID AND OSO.ID = FTKM.ID