VIEW: OLAPSYS.ALL$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
      dim.invalid = 'N' and
      h.hidden = 'N' and
       (cwm2$security.dimension_tables_visible(dim.irid) = 'Y'
       OR EXISTS (select null from v$enabledprivs
                  where priv_number in (-47, -215, -216, -217)))
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 DIM.INVALID = 'N' AND H.HIDDEN = 'N' AND (CWM2$SECURITY.DIMENSION_TABLES_VISIBLE(DIM.IRID) = 'Y' OR EXISTS (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-47
, -215
, -216
, -217))) AND DIM.IRID = CE.ELEMENT_IRID (+) AND CE.NAME (+) = 'DIMENSION2' WITH READ ONLY