DBA Data[Home] [Help]

VIEW: OLAPSYS.EXPORTOLAPMR_DIMENSIONS

Source

View Text - Preformatted

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
View Text - HTML Formatted

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