SELECT
u.username owner,
o.name dimension_name,
dim.pluralname plural_name,
dim.displayname display_name,
dim.description short_description,
dim.description description,
display_hierarchy_name default_display_hierarchy,
o.status status,
dim.irid irid, -- added for export
'CWM1' model -- added for export
FROM
sys.dim$ d,
dba_users u,
sys.obj$ o,
cwm$dimension dim
WHERE o.type# = 43 AND
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 SHORT_DESCRIPTION
,
DIM.DESCRIPTION DESCRIPTION
,
DISPLAY_HIERARCHY_NAME DEFAULT_DISPLAY_HIERARCHY
,
O.STATUS STATUS
,
DIM.IRID IRID
, -- ADDED FOR EXPORT
'CWM1' MODEL -- ADDED FOR EXPORT
FROM
SYS.DIM$ D
,
DBA_USERS U
,
SYS.OBJ$ O
,
CWM$DIMENSION DIM
WHERE O.TYPE# = 43 AND
U.USER_ID = O.OWNER# AND
O.OBJ# = D.OBJ# AND
D.OBJ# = DIM.IRID
WITH READ ONLY
|
|
|