eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: OLAPSYS.ALL$OLAP2UDIMENSIONS

Source

View Text - Preformatted


select mrd.owner owner,
       mrd.dimension_name dimension_name,
       mrd.plural_name plural_name,
       mrd.display_name display_name,
       mrd.short_description short_description,
       mrd.description description,
       mrd.default_display_hierarchy default_display_hierarchy,
       decode(mrd.status, 5, 'Y', 'N') invalid,
       'HIER' dimension_type
from olapsys.all$olapmr_dimensions mrd
union all
select owner, dimension_name, plural_name, display_name, short_description,
       description, default_display_hierarchy, invalid, dimension_type
from olapsys.all$olap2_dimensions
with read only

View Text - HTML Formatted

SELECT MRD.OWNER OWNER
, MRD.DIMENSION_NAME DIMENSION_NAME
, MRD.PLURAL_NAME PLURAL_NAME
, MRD.DISPLAY_NAME DISPLAY_NAME
, MRD.SHORT_DESCRIPTION SHORT_DESCRIPTION
, MRD.DESCRIPTION DESCRIPTION
, MRD.DEFAULT_DISPLAY_HIERARCHY DEFAULT_DISPLAY_HIERARCHY
, DECODE(MRD.STATUS
, 5
, 'Y'
, 'N') INVALID
, 'HIER' DIMENSION_TYPE FROM OLAPSYS.ALL$OLAPMR_DIMENSIONS MRD UNION ALL SELECT OWNER
, DIMENSION_NAME
, PLURAL_NAME
, DISPLAY_NAME
, SHORT_DESCRIPTION
, DESCRIPTION
, DEFAULT_DISPLAY_HIERARCHY
, INVALID
, DIMENSION_TYPE FROM OLAPSYS.ALL$OLAP2_DIMENSIONS WITH READ ONLY