VIEW: OLAPSYS.DBA$OLAP2_CUBE_MEASURE_MAPS

Source

View Text - Preformatted

select distinct c.owner owner,
  c.name cube_name,
  m.name measure_name,
  fdhm.irid dim_hier_combo_id,
  u.username fact_table_owner,
  o.name fact_table_name,
  col.name column_name
from olapsys.CwM2$Cube c,
     olapsys.CwM2$Measure m,
     olapsys.CwM2$MeasureTableMap mtm,
     olapsys.CwM2$Dimension d,
     olapsys.CwM2$CubeDimensionUse cdu,
     olapsys.CwM2$FactDimHierMap fdhm,
     sys.obj$ o,
     dba_users u,
     sys.col$ col
where c.irid = m.cube_irid and
      d.irid = cdu.dimension_irid and
      c.irid = cdu.cube_irid and
      m.irid = mtm.measure_irid and
      fdhm.cube_irid = c.irid and
      mtm.FactDimHier_IRID = fdhm.irid and
      mtm.factcolumn_ID = col.col# and
      mtm.facttablename_ID = o.obj# and
      o.owner# = u.user_id and
      o.obj# = col.obj#
with read only

View Text - HTML Formatted

SELECT DISTINCT C.OWNER OWNER
, C.NAME CUBE_NAME
, M.NAME MEASURE_NAME
, FDHM.IRID DIM_HIER_COMBO_ID
, U.USERNAME FACT_TABLE_OWNER
, O.NAME FACT_TABLE_NAME
, COL.NAME COLUMN_NAME FROM OLAPSYS.CWM2$CUBE C
, OLAPSYS.CWM2$MEASURE M
, OLAPSYS.CWM2$MEASURETABLEMAP MTM
, OLAPSYS.CWM2$DIMENSION D
, OLAPSYS.CWM2$CUBEDIMENSIONUSE CDU
, OLAPSYS.CWM2$FACTDIMHIERMAP FDHM
, SYS.OBJ$ O
, DBA_USERS U
, SYS.COL$ COL WHERE C.IRID = M.CUBE_IRID AND D.IRID = CDU.DIMENSION_IRID AND C.IRID = CDU.CUBE_IRID AND M.IRID = MTM.MEASURE_IRID AND FDHM.CUBE_IRID = C.IRID AND MTM.FACTDIMHIER_IRID = FDHM.IRID AND MTM.FACTCOLUMN_ID = COL.COL# AND MTM.FACTTABLENAME_ID = O.OBJ# AND O.OWNER# = U.USER_ID AND O.OBJ# = COL.OBJ# WITH READ ONLY