VIEW: OLAPSYS.MRV$OLAP1_POP_DIMENSIONS

Source

View Text - Preformatted

select
  dim.irid id
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 and
      cwm$util.dimension_tables_visible(d.obj#) = 'Y'

View Text - HTML Formatted

SELECT DIM.IRID ID 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 AND CWM$UTIL.DIMENSION_TABLES_VISIBLE(D.OBJ#) = 'Y'