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.cubedimensionuse_irid dependent_on_dim_use_id
, cdu.calc_hierarchy_name default_calc_hierarchy_name
FROM
dba_users u
, cwm$model sch
, cwm$cube cub
, cwm$cubedimensionuse cdu
WHERE u.username = sch.physicalname
AND sch.irid = cub.datamodel_irid
AND cub.irid = cdu.cube_irid
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.CUBEDIMENSIONUSE_IRID DEPENDENT_ON_DIM_USE_ID
, CDU.CALC_HIERARCHY_NAME DEFAULT_CALC_HIERARCHY_NAME
FROM
DBA_USERS U
, CWM$MODEL SCH
, CWM$CUBE CUB
, CWM$CUBEDIMENSIONUSE CDU
WHERE U.USERNAME = SCH.PHYSICALNAME
AND SCH.IRID = CUB.DATAMODEL_IRID
AND CUB.IRID = CDU.CUBE_IRID
WITH READ ONLY
|
|
|