VIEW: OLAPSYS.DBA$OLAP2_DIMENSIONS

Source

View Text - Preformatted

select
  d.owner owner,
  d.name dimension_name,
  d.pluralname plural_name,
  d.displayname display_name,
  d.shortdescription short_description,
  d.description description,
  (case when h.hidden = 'N'
        then h.name else null end) default_display_hierarchy,
  d.invalid invalid,
  d.dimensiontype dimension_type
from olapsys.CwM2$dimension d,
     olapsys.CwM2$hierarchy h
where
       d.DefaultHier_IRID = h.irid (+)
with read only

View Text - HTML Formatted

SELECT D.OWNER OWNER
, D.NAME DIMENSION_NAME
, D.PLURALNAME PLURAL_NAME
, D.DISPLAYNAME DISPLAY_NAME
, D.SHORTDESCRIPTION SHORT_DESCRIPTION
, D.DESCRIPTION DESCRIPTION
, (CASE WHEN H.HIDDEN = 'N' THEN H.NAME ELSE NULL END) DEFAULT_DISPLAY_HIERARCHY
, D.INVALID INVALID
, D.DIMENSIONTYPE DIMENSION_TYPE FROM OLAPSYS.CWM2$DIMENSION D
, OLAPSYS.CWM2$HIERARCHY H WHERE D.DEFAULTHIER_IRID = H.IRID (+) WITH READ ONLY