title: Selecting all levels in a hierarchy as a tuple in MDX
body: <p>I made my first cube yesterday.  I'm still new to this, so please forgive any misuse of terminology.  One of my dimensions, let's call it <code>MyDimension1</code> has a hierarchy, let's call it <code>MyHierarchy</code>, with two levels, let's call them <code>Level1</code> and <code>Level2</code>.</p>
  
  <p>I seem to be able to do something like:</p>
  
  <pre><code>SELECT 
  { [Measures].[Whatever] } ON 0,
  { ([MyDimension1].[Level1].[Level1], [MyDimension1].[Level2].[Level2]) } ON 1
  FROM MyCube
  </code></pre>
  
  <p>Which gives me the result I want.  If I understand correctly, the set defining axis 1 contains a tuple with two components(?).  I've read that each component(?) of a tuple is supposed to be from a different dimension, but I seem to be able to specify components of the same dimension, as demonstrated by the above query.  I'd like to be able to just specify the hierarchy by name and then have the server create the tuples for me, though.  So something like:</p>
  
  <pre><code>SELECT 
  { [Measures].[Whatever] } ON 0,
  { AllLevelsToTuple([MyDimension1].[MyHierarchy]) } ON 1
  FROM MyCube
  </code></pre>
  
  <p>But I can't seem to figure out how to do this.  Thanks in advance!</p>
  
  <p><b>EDIT (My example, as requested by an answerer):</b></p>
  
  <p>This does what I want, functionally, but isn't the syntax I'd like:</p>
  
  <pre><code>SELECT [Measures].[Original] ON 0,
  ([Customer].[Customer].[Customer], [Customer].[Account ID].[Account ID]) ON 1
  </code></pre>
  
  <p>Results (In SSMS):</p>
  
  <pre><code>               Original
  ---------  --  --------
  CustomerA  15    306.03
  CustomerA  16    754.20
  ...
  CustomerB  17    524.43
  ...
  CustomerC  22    760.42
  ...
  </code></pre>
  
  <p>When I expand the dimension, it looks like:</p>
  
  <pre><code>- Customer
      - Hierarchy
          + Members
          + Customer
          + Account ID
  </code></pre>
  
  <p>When I do something like (I'd like to do something similar syntactically):</p>
  
  <pre><code>SELECT [Measures].[Original] ON 0,
  ([Customer].[Hierarchy].Members) ON 1
  </code></pre>
  
  <p>I get the following results:</p>
  
  <pre><code>            Original
  ----------  --------
  All         17638.15
  CustomerA    2624.76
  15
  16
  ...
  CustomerB    3113.67
  17            524.43
  ...
  CustomerC    3427.01
  22            760.42
  ...
  </code></pre>
  
  <p>I want there to be 3 columns, not 2, basically.</p>