VIEW: OLAPSYS.DBA$OLAP2_DIM_HIERARCHIES

Source

View Text - Preformatted

select
  d.owner owner,
  d.name dimension_name,
  h.name hierarchy_name,
  h.displayname display_name,
  h.shortdescription short_description,
  h.description description,
  h.solvedcode solved_code
from olapsys.CwM2$dimension d,
     olapsys.CwM2$hierarchy h
where d.irid = h.dimension_irid and
      h.hidden = 'N'
with read only

View Text - HTML Formatted

SELECT D.OWNER OWNER
, D.NAME DIMENSION_NAME
, H.NAME HIERARCHY_NAME
, H.DISPLAYNAME DISPLAY_NAME
, H.SHORTDESCRIPTION SHORT_DESCRIPTION
, H.DESCRIPTION DESCRIPTION
, H.SOLVEDCODE SOLVED_CODE FROM OLAPSYS.CWM2$DIMENSION D
, OLAPSYS.CWM2$HIERARCHY H WHERE D.IRID = H.DIMENSION_IRID AND H.HIDDEN = 'N' WITH READ ONLY