This illustration shows the results of the query.

   YEAR_ID QUARTER_ID MONTH_ID MEMBER_NAME HIER_ORDER
   ------- ---------- -------- ----------- ----------
1  (null)  (null)     (null)   ALL                  0
2  11      (null)     (null)   CY2011               1
3  11      111        (null)   Q1CY2011             2
4  11      111        Jan-11   Jan-11               3
5  11      111        Feb-11   Feb-11               4
6  11      111        Mar-11   Mar-11               5
7  11      211        (null)   Q2CY2011             6
8  11      211        Apr-11   Apr-11               7
9  11      211        May-11   May-11               8
10 11      211        Jun-11   Jun-11               9
11 11      311        (null)   Q3CY2011            10
12 11      311        Jul-11   Jul-11              11
13 11      311        Aug-11   Aug-11              12
14 11      311        Sep-11   Sep-11              13