VIEW: OLAPSYS.ALL$OLAP2UCUBE_MEAS_DIM_USES

Source

View Text - Preformatted

SELECT distinct
  sch.physicalname owner
, cub.physicalname cube_name
, msr.physicalname measure_name
, cdu.dimension_owner
, cdu.dimension_name
, cdu.name dimension_alias
, fu.irid default_aggr_function_use_id
FROM
  dba_users u
, cwm$model sch
, cwm$cube cub
, cwm$measure msr
, cwm$measuredimensionuse mdu
, cwm$cubedimensionuse cdu
, cwm$functionuse fu
, cwm$dimension cd
, dba_users du
, sys.obj$ do
WHERE u.username = sch.physicalname
AND sch.irid = cub.datamodel_irid
AND (cwm$util.fact_table_visible(cub.irid) = 'Y'
     OR EXISTS /* SELECT ANY TABLE */
       (SELECT null FROM v$enabledprivs
        WHERE priv_number = -47))
AND cub.irid = msr.itemcontainer_irid
AND msr.irid = mdu.measure_irid
AND mdu.cubedimensionuse_irid = cdu.irid
AND mdu.irid = fu.measuredimensionuse_irid (+)
AND cub.irid = cdu.cube_irid
AND cdu.dimension_owner = du.username
AND cdu.dimension_name = do.name
AND du.user_id = do.owner#
AND do.type# = 43
AND do.obj# = cd.irid
AND cd.irid = cdu.abstractdimension_irid
union all
select owner, cube_name, measure_name, dimension_owner, dimension_name,
       dimension_alias, default_aggr_function_use_id
from olapsys.all$olap2_cube_meas_dim_uses
with read only

View Text - HTML Formatted

SELECT DISTINCT SCH.PHYSICALNAME OWNER
, CUB.PHYSICALNAME CUBE_NAME
, MSR.PHYSICALNAME MEASURE_NAME
, CDU.DIMENSION_OWNER
, CDU.DIMENSION_NAME
, CDU.NAME DIMENSION_ALIAS
, FU.IRID DEFAULT_AGGR_FUNCTION_USE_ID FROM DBA_USERS U
, CWM$MODEL SCH
, CWM$CUBE CUB
, CWM$MEASURE MSR
, CWM$MEASUREDIMENSIONUSE MDU
, CWM$CUBEDIMENSIONUSE CDU
, CWM$FUNCTIONUSE FU
, CWM$DIMENSION CD
, DBA_USERS DU
, SYS.OBJ$ DO WHERE U.USERNAME = SCH.PHYSICALNAME AND SCH.IRID = CUB.DATAMODEL_IRID AND (CWM$UTIL.FACT_TABLE_VISIBLE(CUB.IRID) = 'Y' OR EXISTS /* SELECT ANY TABLE */ (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER = -47)) AND CUB.IRID = MSR.ITEMCONTAINER_IRID AND MSR.IRID = MDU.MEASURE_IRID AND MDU.CUBEDIMENSIONUSE_IRID = CDU.IRID AND MDU.IRID = FU.MEASUREDIMENSIONUSE_IRID (+) AND CUB.IRID = CDU.CUBE_IRID AND CDU.DIMENSION_OWNER = DU.USERNAME AND CDU.DIMENSION_NAME = DO.NAME AND DU.USER_ID = DO.OWNER# AND DO.TYPE# = 43 AND DO.OBJ# = CD.IRID AND CD.IRID = CDU.ABSTRACTDIMENSION_IRID UNION ALL SELECT OWNER
, CUBE_NAME
, MEASURE_NAME
, DIMENSION_OWNER
, DIMENSION_NAME
, DIMENSION_ALIAS
, DEFAULT_AGGR_FUNCTION_USE_ID FROM OLAPSYS.ALL$OLAP2_CUBE_MEAS_DIM_USES WITH READ ONLY