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.

[Home] [Help]

VIEW: OLAPSYS.ALL$OLAP2UHIERDIMS

Source

View Text - Preformatted


select owner, dimension_name, plural_name, display_name, short_description,
       description, default_display_hierarchy, descriptor_value
from olapsys.all$olap9i1_hier_dimensions
union all
select owner, dimension_name, plural_name, display_name, short_description,
       description, default_display_hierarchy, descriptor_value
from olapsys.all$olap9i2_hier_dimensions
with read only

View Text - HTML Formatted

SELECT OWNER
, DIMENSION_NAME
, PLURAL_NAME
, DISPLAY_NAME
, SHORT_DESCRIPTION
, DESCRIPTION
, DEFAULT_DISPLAY_HIERARCHY
, DESCRIPTOR_VALUE FROM OLAPSYS.ALL$OLAP9I1_HIER_DIMENSIONS UNION ALL SELECT OWNER
, DIMENSION_NAME
, PLURAL_NAME
, DISPLAY_NAME
, SHORT_DESCRIPTION
, DESCRIPTION
, DEFAULT_DISPLAY_HIERARCHY
, DESCRIPTOR_VALUE FROM OLAPSYS.ALL$OLAP9I2_HIER_DIMENSIONS WITH READ ONLY