Description of illustration time_hier_col_subset_determines.png

This is the result of the query.

   LEVEL_NAME   YEAR_ID QUARTER_ID MONTH_ID MEMBER_UNIIQE_NAME
   ----------   ------- ---------- -------- ------------------
1  ALL          (null)  (null)     (null)   [ALL].[ALL]
2  YEAR         11      (null)     (null)   [YEAR].&[11]
3  QUARTER      11      111        (null)   [QUARTER].&[111]
4  MONTH        11      111        Jan-11   [MONTH].&[Jan-11]
5  MONTH        11      111        Feb-11   [MONTH].&[Feb-11]
6  MONTH        11      111        Mar-11   [MONTH].&[Mar-11]
7  QUARTER      11      211        (null)   [QUARTER].&[211]
8  MONTH        11      211        Apr-11   [MONTH].&[Apr-11]
9  MONTH        11      211        May-11   [MONTH].&[May-11]
10 MONTH        11      211        Jun-11   [MONTH].&[Jun-11]
11 QUARTER      11      311        (null)   [QUARTER].&[311]
12 MONTH        11      311        Jul-11   [MONTH].&[Jul-11]
13 MONTH        11      311        Aug-11   [MONTH].&[Aug-11]
14 MONTH        11      311        Sep-11   [MONTH].&[Sep-11]