title: SSAS using hierarchy without putting it in the select
body: <p>We have a hierarchy in the time dimension and we try to get some data using the hierarchy of the dimension but we do not want to put the hierarchy in the where clause.
  This is the code:</p>
  
  <pre><code>with
  
  member Measures.last_month as   
          sum(
          ParallelPeriod(
                  [TIME].[Periods].[Level 06],1
          ), 
          [Ims Units])
  select 
  
      {[Ims Units],last_month} on columns,
       [TIME].[Periods].[Level 06].members on rows
  from [Analyzer cube]
  </code></pre>
  
  <p>It returns all the months, specifically:</p>
  
  <p>February 2011: 47271 on [ims units] and, 51103 on last_month</p>
  
  <p>March 2011: 55293 on [ims units] and, 47271 on last_month</p>
  
  <p>But if I add the the were clause and remove the hierarchy in the select clause:</p>
  
  <pre><code>with
  
  member Measures.last_month as   
          sum(
          ParallelPeriod(
                  [TIME].[Periods].[Level 06],1
          ), 
          [Ims Units])
  select 
      {[Ims Units],last_month} on columns
  from [Analyzer cube]
  where [TIME].[MONTH NAME].&amp;[201103 March]
  </code></pre>
  
  <p>It shows:</p>
  
  <p>March 2011: 55293 on [ims units] and, null on last_month</p>
  
  <p>We have the null on the last_month because it has been filtered the time dimension.
  Is there any way to get the last month without putting the hierarchy on the select clause and either on the where clause and still using the parallelperiod function? (the use of the ParallelPeriod is just an example)</p>
  
  <p>Thanks,
  Francisco</p>