VIEW: OLAPSYS.DBA$OLAP2_AGG_WEIGHTBY_USES

Source

View Text - Preformatted

select
  c.owner owner,
  c.name cube_name,
  d.owner dimension_owner,
  d.name dimension_name,
  (case when h.hidden = 'N'
        then h.name else null end) hierarchy_name,
  fdhm.irid dim_hier_combo_id,
  f.name aggregation_name,
  fkdhm.aggorder aggregation_order,
  u.username table_owner,
  o.name table_name,
  col.name column_name
from olapsys.CwM2$Cube c,
     olapsys.CwM2$Dimension d,
     olapsys.CwM2$CubeDimensionUse cdu,
     olapsys.CwM2$FactDimHierMap fdhm,
     olapsys.CwM2$FactDimHierTplsDtl fdhtd,
     olapsys.CwM2$FactKeyDimHierMap fkdhm,
     olapsys.CwM2$Hierarchy h,
     olapsys.cwm$Function f,
     sys.obj$ o,
     dba_users u,
     sys.col$ col
where c.irid = cdu.cube_irid and
      d.irid = cdu.dimension_irid and
      h.dimension_irid = d.irid and
      fdhm.cube_irid = c.irid and
      fkdhm.factDimHier_IRID = fdhm.irid and
      fkdhm.dimension_irid = d.irid and
      fdhm.irid = fdhtd.factdimhier_irid and
      h.irid = fdhtd.hier_irid and
      fkdhm.aggoperator_irid = f.irid and
      u.user_id = o.owner# and
      o.obj# = col.obj# and
      col.col# = fkdhm.AggWeightCol_ID and
      col.obj# = fkdhm.AggWeightTbl_ID
with read only

View Text - HTML Formatted

SELECT C.OWNER OWNER
, C.NAME CUBE_NAME
, D.OWNER DIMENSION_OWNER
, D.NAME DIMENSION_NAME
, (CASE WHEN H.HIDDEN = 'N' THEN H.NAME ELSE NULL END) HIERARCHY_NAME
, FDHM.IRID DIM_HIER_COMBO_ID
, F.NAME AGGREGATION_NAME
, FKDHM.AGGORDER AGGREGATION_ORDER
, U.USERNAME TABLE_OWNER
, O.NAME TABLE_NAME
, COL.NAME COLUMN_NAME FROM OLAPSYS.CWM2$CUBE C
, OLAPSYS.CWM2$DIMENSION D
, OLAPSYS.CWM2$CUBEDIMENSIONUSE CDU
, OLAPSYS.CWM2$FACTDIMHIERMAP FDHM
, OLAPSYS.CWM2$FACTDIMHIERTPLSDTL FDHTD
, OLAPSYS.CWM2$FACTKEYDIMHIERMAP FKDHM
, OLAPSYS.CWM2$HIERARCHY H
, OLAPSYS.CWM$FUNCTION F
, SYS.OBJ$ O
, DBA_USERS U
, SYS.COL$ COL WHERE C.IRID = CDU.CUBE_IRID AND D.IRID = CDU.DIMENSION_IRID AND H.DIMENSION_IRID = D.IRID AND FDHM.CUBE_IRID = C.IRID AND FKDHM.FACTDIMHIER_IRID = FDHM.IRID AND FKDHM.DIMENSION_IRID = D.IRID AND FDHM.IRID = FDHTD.FACTDIMHIER_IRID AND H.IRID = FDHTD.HIER_IRID AND FKDHM.AGGOPERATOR_IRID = F.IRID AND U.USER_ID = O.OWNER# AND O.OBJ# = COL.OBJ# AND COL.COL# = FKDHM.AGGWEIGHTCOL_ID AND COL.OBJ# = FKDHM.AGGWEIGHTTBL_ID WITH READ ONLY