SELECT cdu.irid cube_dimension_use_id
, sch.physicalname owner
, cub.physicalname cube_name
, cdu.dimension_owner
, cdu.dimension_name
, cdu.name dimension_alias
, cdu.calc_hierarchy_name default_calc_hierarchy_name
, cdu.cubedimensionuse_irid dependent_on_dim_use_id
FROM
dba_users u
, cwm$model sch
, cwm$cube cub
, cwm$cubedimensionuse cdu
, cwm$dimension cd
, dba_users du
, sys.obj$ do
WHERE u.username = sch.physicalname
AND sch.irid = cub.datamodel_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.obj# = cd.irid
AND do.type# = 43
AND cd.irid = cdu.abstractdimension_irid
AND (cwm$util.fact_table_visible(cub.irid) = 'Y'
OR EXISTS /* SELECT ANY TABLE */
(SELECT null FROM v$enabledprivs
WHERE priv_number = -47))
union all
select cube_dimension_use_id, owner, cube_name, dimension_owner,
dimension_name, dimension_alias, default_calc_hierarchy_name,
dependent_on_dim_use_id
from olapsys.all$olap2_cube_dim_uses
with read only
SELECT CDU.IRID CUBE_DIMENSION_USE_ID
, SCH.PHYSICALNAME OWNER
, CUB.PHYSICALNAME CUBE_NAME
, CDU.DIMENSION_OWNER
, CDU.DIMENSION_NAME
, CDU.NAME DIMENSION_ALIAS
, CDU.CALC_HIERARCHY_NAME DEFAULT_CALC_HIERARCHY_NAME
, CDU.CUBEDIMENSIONUSE_IRID DEPENDENT_ON_DIM_USE_ID
FROM
DBA_USERS U
, CWM$MODEL SCH
, CWM$CUBE CUB
, CWM$CUBEDIMENSIONUSE CDU
, CWM$DIMENSION CD
, DBA_USERS DU
, SYS.OBJ$ DO
WHERE U.USERNAME = SCH.PHYSICALNAME
AND SCH.IRID = CUB.DATAMODEL_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.OBJ# = CD.IRID
AND DO.TYPE# = 43
AND CD.IRID = CDU.ABSTRACTDIMENSION_IRID
AND (CWM$UTIL.FACT_TABLE_VISIBLE(CUB.IRID) = 'Y'
OR EXISTS /* SELECT ANY TABLE */
(SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER = -47))
UNION ALL
SELECT CUBE_DIMENSION_USE_ID
, OWNER
, CUBE_NAME
, DIMENSION_OWNER
,
DIMENSION_NAME
, DIMENSION_ALIAS
, DEFAULT_CALC_HIERARCHY_NAME
,
DEPENDENT_ON_DIM_USE_ID
FROM OLAPSYS.ALL$OLAP2_CUBE_DIM_USES
WITH READ ONLY
|
|
|