VIEW: OLAPSYS.DBA$OLAP9I2_HIER_DIMENSIONS

Source

View Text - Preformatted

SELECT distinct
  dim.owner               owner,
  dim.name                dimension_name,
  dim.pluralname          plural_name,
  dim.displayname         display_name,
  dim.shortdescription    short_description,
  dim.description         description,
  h.name                 default_display_hierarchy,
  (case when ce.classification_irid = 28 then 'Time'
       else 'Other'
       end)    descriptor_value
FROM
  olapsys.cwm2$dimension           dim,
  olapsys.cwm2$hierarchy h,
  olapsys.cwm$classificationentry ce
WHERE
      (dim.defaulthier_irid = h.irid  or
       dim.irid in (select irid from olapsys.cwm2$hierarchy))
and
      h.hidden = 'N'
AND dim.irid = ce.element_irid (+) and
    ce.name (+) = 'DIMENSION2'
WITH READ ONLY

View Text - HTML Formatted

SELECT DISTINCT DIM.OWNER OWNER
, DIM.NAME DIMENSION_NAME
, DIM.PLURALNAME PLURAL_NAME
, DIM.DISPLAYNAME DISPLAY_NAME
, DIM.SHORTDESCRIPTION SHORT_DESCRIPTION
, DIM.DESCRIPTION DESCRIPTION
, H.NAME DEFAULT_DISPLAY_HIERARCHY
, (CASE WHEN CE.CLASSIFICATION_IRID = 28 THEN 'TIME' ELSE 'OTHER' END) DESCRIPTOR_VALUE FROM OLAPSYS.CWM2$DIMENSION DIM
, OLAPSYS.CWM2$HIERARCHY H
, OLAPSYS.CWM$CLASSIFICATIONENTRY CE WHERE (DIM.DEFAULTHIER_IRID = H.IRID OR DIM.IRID IN (SELECT IRID
FROM OLAPSYS.CWM2$HIERARCHY)) AND H.HIDDEN = 'N' AND DIM.IRID = CE.ELEMENT_IRID (+) AND CE.NAME (+) = 'DIMENSION2' WITH READ ONLY