VIEW: OLAPSYS.ALL$OLAP2UDIM_HIERS

Source

View Text - Preformatted

select
 h.owner owner,
 h.dimension_name dimension_name,
 h.hierarchy_name hierarchy_name,
 h.display_name display_name,
 h.short_description short_description,
 h.description description,
 h.solved_code solved_code,
 'Y' is_default
from olapsys.all$olap2udimensions d,
     olapsys.all$olap2udim_hierarchies h
where d.owner = h.owner and d.dimension_name = h.dimension_name
and d.default_display_hierarchy = h.hierarchy_name
union
select
 h.owner owner,
 h.dimension_name dimension_name,
 h.hierarchy_name hierarchy_name,
 h.display_name display_name,
 h.short_description short_description,
 h.description description,
 h.solved_code solved_code,
 'N' is_default
from olapsys.all$olap2udim_hierarchies h
where not exists (select * from olapsys.all$olap2udimensions d
where d.owner = h.owner and d.dimension_name = h.dimension_name
and d.default_display_hierarchy = h.hierarchy_name)

View Text - HTML Formatted

SELECT H.OWNER OWNER
, H.DIMENSION_NAME DIMENSION_NAME
, H.HIERARCHY_NAME HIERARCHY_NAME
, H.DISPLAY_NAME DISPLAY_NAME
, H.SHORT_DESCRIPTION SHORT_DESCRIPTION
, H.DESCRIPTION DESCRIPTION
, H.SOLVED_CODE SOLVED_CODE
, 'Y' IS_DEFAULT FROM OLAPSYS.ALL$OLAP2UDIMENSIONS D
, OLAPSYS.ALL$OLAP2UDIM_HIERARCHIES H WHERE D.OWNER = H.OWNER
AND D.DIMENSION_NAME = H.DIMENSION_NAME AND D.DEFAULT_DISPLAY_HIERARCHY = H.HIERARCHY_NAME UNION SELECT H.OWNER OWNER
, H.DIMENSION_NAME DIMENSION_NAME
, H.HIERARCHY_NAME HIERARCHY_NAME
, H.DISPLAY_NAME DISPLAY_NAME
, H.SHORT_DESCRIPTION SHORT_DESCRIPTION
, H.DESCRIPTION DESCRIPTION
, H.SOLVED_CODE SOLVED_CODE
, 'N' IS_DEFAULT FROM OLAPSYS.ALL$OLAP2UDIM_HIERARCHIES H WHERE NOT EXISTS (SELECT *
FROM OLAPSYS.ALL$OLAP2UDIMENSIONS D WHERE D.OWNER = H.OWNER
AND D.DIMENSION_NAME = H.DIMENSION_NAME AND D.DEFAULT_DISPLAY_HIERARCHY = H.HIERARCHY_NAME)