title: Arbitrarily picking a dimension to add members to
body: <p>The following script gives exactly the result I want.</p>
  
  <p>It feels like a hack as I've added the custom members <code>VALUE</code> and <code>VALUE_MTD</code> onto the hierarchy <code>[Customer].[Country]</code>. I've chosen this hierarchy arbitrarily - just not used <code>[Measures]</code> or <code>[Date].[Calendar]</code> as they are already in use.</p>
  
  <p>Is there a more standard approach to returning exactly the same set of cells?</p>
  
  <pre><code>WITH 
    MEMBER [Customer].[Country].[VALUE] AS 
      Aggregate([Customer].[Country].[(All)].MEMBERS) 
    MEMBER [Customer].[Country].[VALUE_MTD] AS 
      Aggregate
      (
        PeriodsToDate
        (
          [Date].[Calendar].[Month]
         ,[Date].[Calendar].CurrentMember
        )
       ,[Customer].[Country].[VALUE]
      ) 
  SELECT 
    {
      [Customer].[Country].[VALUE]
     ,[Customer].[Country].[VALUE_MTD]
    } ON 0
   ,NON EMPTY 
        {
          [Measures].[Internet Sales Amount]
         ,[Measures].[Internet Order Quantity]
        }
      * 
        Descendants
        (
          {
              [Date].[Calendar].[Month].&amp;[2007]&amp;[12]
            : 
              [Date].[Calendar].[Month].&amp;[2008]&amp;[01]
          }
         ,[Date].[Calendar].[Date]
        ) ON 1
  FROM [Adventure Works];
  </code></pre>