This illustration shows the results of the query.
YEAR_ID QUARTER_ID MONTH_ID MEMBER_NAME MEMBER_UNIQUE_NAME MEMBER_CAPTION MEMBER_DESCRIPTION ------- ---------- -------- ----------- ------------------ -------------- ------------------ 1 (null) (null) (null) ALL [ALL].[ALL] (null) (null) 2 11 (null) (null) CY2011 [YEAR].&[11] CY2011 CY2011 3 11 (null) 111 Q1CY2011 [QUARTER].&[11]&[111] Q1CY2011 Q1CY2011 4 11 111 Jan-11 Jan-11 [MONTH].&[11]&[111]&[Jan-11] Jan-11 January 2011 5 11 111 Feb-11 Feb-11 [MONTH].&[11]&[111]&[Feb-11] Feb-11 February 2011 6 11 111 Mar-11 Mar-11 [MONTH].&[11]&[111]&[Mar-11] Mar-11 March 2011 7 11 211 (null) Q2CY2011 [QUARTER].&[11]&[211] Q2CY2011 Q2CY2011 8 11 211 Apr-11 Apr-11 [MONTH].&[11]&[211]&[Apr-11] Apr-11 April 2011 9 11 211 May-11 May-11 [MONTH].&[11]&[211]&[May-11] May-11 May 2011 10 11 211 Jun-11 Jun-11 [MONTH].&[11]&[211]&[Jun-11] Jun-11 June 2011 11 11 311 (null) Q3CY2011 [QUARTER].&[11]&[311] Q3CY2011 Q3CY2011 12 11 311 Jul-11 Jul-11 [MONTH].&[11]&[311]&[Jul-11] Jul-11 July 2011 13 11 311 Aug-11 Aug-11 [MONTH].&[11]&[311]&[Aug-11] Aug-11 August 2011 14 11 311 Sep-11 Sep-11 [MONTH].&[11]&[311]&[Sep-11] Sep-11 September 2011