Description of the illustration time_hier_col_subset_orderby.png
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