﻿          WITH
          SET [sorted set] AS
          Hierarchize
          (
          (DISTINCT
          {
          AddCalculatedMembers
          (
          {
		  [Geography].[Geography].[All Geographies],
          [Geography].[Geography].[All Geographies].Children
          }
          )
          })
          )
          SELECT
          NON EMPTY
          {[Date].[Calendar].[Calendar Year].Members}
          *{
			[Measures].[Reseller Sales Amount]
		    ,[Measures].[Reseller Gross Profit]
          } DIMENSION PROPERTIES  PARENT_UNIQUE_NAME,PARENT_LEVEL,MEMBER_TYPE,MEMBER_VALUE
          ON 0
          ,NON EMPTY
          {[sorted set]} DIMENSION PROPERTIES  PARENT_UNIQUE_NAME,PARENT_LEVEL,MEMBER_TYPE,MEMBER_VALUE
          ON 1
          FROM [Adventure Works]
          CELL PROPERTIES
          CELL_ORDINAL
          ,VALUE
          ,FORMATTED_VALUE
          ,FORMAT_STRING
          ,FORE_COLOR
          ,BACK_COLOR
          ,FONT_SIZE
          ,ACTION_TYPE
          ,FONT_NAME
          ,FONT_FLAGS
          ,UPDATEABLE;