VIEW: OLAPSYS.MRV$OLAP2_FACTTBLKEYMAPS

Source

View Text - Preformatted

select
  ftkm.owner owner,
  ftkm.cube_name cube_name,
  ftkm.dim_hier_combo_id dim_hier_combo_id,
  ftkm.dimension_owner dimension_owner,
  ftkm.dimension_name dimension_name,
  ftkm.hierarchy_name hierarchy_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_data_type column_data_type,
  ftkm.column_data_length column_data_length,
  ftkm.column_data_precision column_data_precision,
  ftkm.gid_column_name gid_column_name,
  ftkm.gid_column_data_type gid_column_data_type,
  ftkm.gid_column_data_length gid_column_data_length,
  ftkm.gid_column_data_precision gid_column_data_precision,
  ftkm.dimension_keymap_type dimension_keymap_type,
  ftkm.mv_summarycode mv_summarycode,
  ftkm.column_position column_position
 from olapsys.cwm2$mrall_facttblkeymaps 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.DIM_HIER_COMBO_ID DIM_HIER_COMBO_ID
, FTKM.DIMENSION_OWNER DIMENSION_OWNER
, FTKM.DIMENSION_NAME DIMENSION_NAME
, FTKM.HIERARCHY_NAME HIERARCHY_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_DATA_TYPE COLUMN_DATA_TYPE
, FTKM.COLUMN_DATA_LENGTH COLUMN_DATA_LENGTH
, FTKM.COLUMN_DATA_PRECISION COLUMN_DATA_PRECISION
, FTKM.GID_COLUMN_NAME GID_COLUMN_NAME
, FTKM.GID_COLUMN_DATA_TYPE GID_COLUMN_DATA_TYPE
, FTKM.GID_COLUMN_DATA_LENGTH GID_COLUMN_DATA_LENGTH
, FTKM.GID_COLUMN_DATA_PRECISION GID_COLUMN_DATA_PRECISION
, FTKM.DIMENSION_KEYMAP_TYPE DIMENSION_KEYMAP_TYPE
, FTKM.MV_SUMMARYCODE MV_SUMMARYCODE
, FTKM.COLUMN_POSITION COLUMN_POSITION
FROM OLAPSYS.CWM2$MRALL_FACTTBLKEYMAPS FTKM
, OLAPSYS.OLAP_SESSION_OBJECTS OSO
WHERE OSO.VERSION_ID = FTKM.VERSION_ID AND OSO.ID = FTKM.ID