SELECT DISTINCT
sch.physicalname owner
, cub.physicalname cube_name
, cwm$util.cube_invalid(cub.irid) invalid
, cub.displayname display_name
, cub.description short_description
, cub.description description
, nvl(cub.mvsummarycode, 'RU') mv_summarycode
, cub.irid irid -- add for export
, 'CWM1' model -- add for export
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 cdu.cube_irid = cub.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
WITH READ ONLY
SELECT DISTINCT
SCH.PHYSICALNAME OWNER
, CUB.PHYSICALNAME CUBE_NAME
, CWM$UTIL.CUBE_INVALID(CUB.IRID) INVALID
, CUB.DISPLAYNAME DISPLAY_NAME
, CUB.DESCRIPTION SHORT_DESCRIPTION
, CUB.DESCRIPTION DESCRIPTION
, NVL(CUB.MVSUMMARYCODE
, 'RU') MV_SUMMARYCODE
, CUB.IRID IRID -- ADD FOR EXPORT
, 'CWM1' MODEL -- ADD FOR EXPORT
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 CDU.CUBE_IRID = CUB.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
WITH READ ONLY
|
|
|