VIEW: OLAPSYS.ALL$OLAP2_CUBE_DIM_USES

Source

View Text - Preformatted

select
  cdu.irid cube_dimension_use_id,
  c.owner owner,
  c.name cube_name,
  d.owner dimension_owner,
  d.name dimension_name,
  null dimension_alias,
  (case when h.hidden = 'N' then h.name
        else null end) default_calc_hierarchy_name,
  null dependent_on_dim_use_id
from olapsys.CwM2$CubeDimensionUse cdu,
     olapsys.CwM2$Cube c,
     olapsys.CwM2$Dimension d,
     olapsys.CwM2$hierarchy h
where c.irid = cdu.cube_irid and
      d.irid = cdu.dimension_irid and
      cdu.DefaultCalcHier_IRID = h.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 CDU.IRID CUBE_DIMENSION_USE_ID
, C.OWNER OWNER
, C.NAME CUBE_NAME
, D.OWNER DIMENSION_OWNER
, D.NAME DIMENSION_NAME
, NULL DIMENSION_ALIAS
, (CASE WHEN H.HIDDEN = 'N' THEN H.NAME ELSE NULL END) DEFAULT_CALC_HIERARCHY_NAME
, NULL DEPENDENT_ON_DIM_USE_ID FROM OLAPSYS.CWM2$CUBEDIMENSIONUSE CDU
, OLAPSYS.CWM2$CUBE C
, OLAPSYS.CWM2$DIMENSION D
, OLAPSYS.CWM2$HIERARCHY H WHERE C.IRID = CDU.CUBE_IRID AND D.IRID = CDU.DIMENSION_IRID AND CDU.DEFAULTCALCHIER_IRID = H.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