VIEW: OLAPSYS.ALL$OLAP2_AGG_OPERATOR_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
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
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
       (c.invalid = 'N' or c.invalid = 'O') and
       (cwm2$security.fact_table_visible(c.irid) = 'Y'
       OR EXISTS (select null from v$enabledprivs
                  where priv_number in (-47)))
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 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 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 (C.INVALID = 'N' OR C.INVALID = 'O') AND (CWM2$SECURITY.FACT_TABLE_VISIBLE(C.IRID) = 'Y' OR EXISTS (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-47))) WITH READ ONLY