﻿          WITH
          SET [sorted set] AS
          Hierarchize
          (
          (DISTINCT
          {
          AddCalculatedMembers
          (
          {
		  [Geography].[Geography].[All Geographies],
          [Geography].[Geography].[All Geographies].Children
          }
          )
          })
          )
          SELECT
          NON EMPTY
          {[Date].[Calendar].[Calendar Quarter].Members}
          *{
          [Measures].[Reseller Sales Amount]
		  ,[Measures].[Reseller Order Count]
		  ,[Measures].[Reseller Gross Profit]
		  ,[Measures].[Reseller Gross Profit Margin]
          } 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;