Change: dmn,dmn, hierarchy_name,hierarchy_name, '('||order_num||') '||level_name level_name from all_cube_hier_levels order by 1,2,order_num;DIMENSION .... HIERARCHY ....... LEVEL-------------- ----------------- ---------------------DM.CHANNEL.... SALES_CHANNEL.... (0) TOTAL_CHANNEL................................ (1) CLASS................................ (2) CHANNELDM.CUSTOMER... REGIONAL ........ (0) TOTAL_CUSTOMER................................ (1) CONTINENT................................ (2) COUNTRY................................ (3) STATE_PROVINCE................................   View changes from previous version. (Word count: 118)

Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 118)

Change: SAMPLE set lines 110 pages 1000 col dmn for a20 hea DIMENSION col hierarchy_name for a20 hea HIERARCHY col level_name for a25 hea LEVELbreak on dmn on hierarchy_name skip 1select owner||'.'||dimension_name dmn, hierarchy_name, '('||order_num||') '||level_name level_namefrom all_cube_hier_levels order by 1,2,order_num;DIMENSION .......... HIERARCHY .......... LEVEL--------------------   View changes from previous version. (Word count: 118)

Change: Created by olapdba Jan 9 2008, 12:31 PM EST for: no reason given