SELECT
u.username owner
, o.name dimension_name
, dim.pluralname plural_name
, dim.displayname display_name
, dim.description description
, display_hierarchy_name default_display_hierarchy
, decode(o.status, 5, 'Y', 'N') invalid
, cwm$util.dim_valid(o.obj#) olap_valid
FROM
dba_users u
, sys.obj$ o
, sys.dim$ d
, cwm$dimension dim
WHERE u.user_id = o.owner#
AND o.obj# = d.obj#
AND d.obj# = dim.irid (+)
WITH READ ONLY
SELECT
U.USERNAME OWNER
, O.NAME DIMENSION_NAME
, DIM.PLURALNAME PLURAL_NAME
, DIM.DISPLAYNAME DISPLAY_NAME
, DIM.DESCRIPTION DESCRIPTION
, DISPLAY_HIERARCHY_NAME DEFAULT_DISPLAY_HIERARCHY
, DECODE(O.STATUS
, 5
, 'Y'
, 'N') INVALID
, CWM$UTIL.DIM_VALID(O.OBJ#) OLAP_VALID
FROM
DBA_USERS U
, SYS.OBJ$ O
, SYS.DIM$ D
, CWM$DIMENSION DIM
WHERE U.USER_ID = O.OWNER#
AND O.OBJ# = D.OBJ#
AND D.OBJ# = DIM.IRID (+)
WITH READ ONLY
|
|
|