Copyright © 2001, 2017, Oracle and/or its affiliates. All rights reserved.
This illustration shows the rightmost eight columns and first eleven rows of the results of the query.
MEMBER_DESCRIPTION LEVEL_NAME HIER_ORDER DEPTH IS_LEAF PARENT_LEVEL_NAME PARENT_UNIQUE_NAME SALES ------------------ ---------- ---------- ----- ------- ----------------- ------------------ --------------- (null) ALL 0 0 0 (null) (null) 36418586335.29 CY2011 YEAR 1 1 0 ALL [ALL].[ALL] 6755115980.73 Q1CY2011 QUARTER 2 2 0 YEAR [YEAR].&[11] 1625299627.35 January 2011 MONTH 3 3 1 QUARTER [QUARTER].&[111] 545626198.98 February 2011 MONTH 4 3 1 QUARTER [QUARTER].&[111] 516587219 March 2011 MONTH 5 3 1 QUARTER [QUARTER].&[111] 563086209.37 Q2CY2011 QUARTER 6 2 0 YEAR [YEAR].&[11] 1715160208.04 April 2011 MONTH 7 3 1 QUARTER [QUARTER].&[211] 556371561.43 May 2011 MONTH 8 3 1 QUARTER [QUARTER].&[211] 583962050.22 June 2011 MONTH 9 3 1 QUARTER [QUARTER].&[211] 574826596.39 Q3CY2011 QUARTER 10 2 0 YEAR [YEAR].&[11] 1691017692.94