VIEW: OLAPSYS.MRV$OLAP2_JOIN_KEY_COL_USES

Source

View Text - Preformatted

select
  jkcu.owner owner,
  jkcu.dimension_name dimension_name,
  jkcu.hierarchy_name hierarchy_name,
  jkcu.child_level_name child_level_name,
  jkcu.table_owner table_owner,
  jkcu.table_name table_name,
  jkcu.column_name column_name,
  jkcu.position position,
  jkcu.join_key_type join_key_type
 from olapsys.cwm2$mrall_join_key_col_uses jkcu,
      olapsys.olap_session_objects oso
 where oso.version_id = jkcu.version_id and
       oso.id = jkcu.id

View Text - HTML Formatted

SELECT JKCU.OWNER OWNER
, JKCU.DIMENSION_NAME DIMENSION_NAME
, JKCU.HIERARCHY_NAME HIERARCHY_NAME
, JKCU.CHILD_LEVEL_NAME CHILD_LEVEL_NAME
, JKCU.TABLE_OWNER TABLE_OWNER
, JKCU.TABLE_NAME TABLE_NAME
, JKCU.COLUMN_NAME COLUMN_NAME
, JKCU.POSITION POSITION
, JKCU.JOIN_KEY_TYPE JOIN_KEY_TYPE
FROM OLAPSYS.CWM2$MRALL_JOIN_KEY_COL_USES JKCU
, OLAPSYS.OLAP_SESSION_OBJECTS OSO
WHERE OSO.VERSION_ID = JKCU.VERSION_ID AND OSO.ID = JKCU.ID