title: Alias MDX Query SSAS
body: <pre><code>WITH MEMBER [Measures].[NetPromoterScore] AS (IIF(([Measures].[Net Promoter Score] = 1/0 OR 
  [Measures].[Net Promoter Score] = -1/0 OR ISEMPTY([Measures].[Net Promoter Score]) 
  OR [Measures].[Avg Revenue Per Unit] = 1/0 OR [Measures].[Avg Revenue Per Unit] = -1/0 OR 
  ISEMPTY([Measures].[Avg Revenue Per Unit]) ), NULL, [Measures].[Net Promoter Score])) 
  
  MEMBER [Measures].[AvgRevenuePerUnit] AS (IIF(([Measures].[Net Promoter Score] = 1/0 
  OR [Measures].[Net Promoter Score] = -1/0 OR ISEMPTY([Measures].[Net Promoter Score]) 
  OR [Measures].[Avg Revenue Per Unit] = 1/0 OR [Measures].[Avg Revenue Per Unit] = -1/0 
  OR ISEMPTY([Measures].[Avg Revenue Per Unit]) ), NULL, [Measures].[Avg Revenue Per Unit]))
  
  SELECT NON EMPTY
         { {[Measures].[NetPromoterScore],[Measures].[AvgRevenuePerUnit]} }
         ON COLUMNS ,
         NON EMPTY
         {{Hierarchize(DrilldownLevel({[Roles].[Enterprise Role].[ALL]}))}}
         DIMENSION  PROPERTIES MEMBER_CAPTION,  MEMBER_UNIQUE_NAME
         ON ROWS
    from Enterprise 
   WHERE (FILTER( [Employees].[EID].[EID],[Measures].[Avg Revenue Per Unit]&gt; 700),
          {[Areas].[Area].&amp;[3]},
          {[Markets].[Market].&amp;[1]},{[Regions].[Region].&amp;[2]},{[Locations].[Location].&amp;[6],[Locations].[Location].&amp;[6]},
          {[Dates].[Date].&amp;[20130219]:[Dates].[Date].&amp;[20130318]})
  </code></pre>
  
  <p>As you see I have aliased [Net Promoter Score] column name with [NetPromoterScore] and [Avg Revenue Per Unit] column name with [AvgRevenuePerUnit]. But in my C# code, the names used are [Net Promoter Score] and [Avg Revenue Per Unit] and I can't change these previous name with new aliased name because I have to make changes in dozens of files and then I have to test whole application. Can I alias twice in the query above to get same previous column names or can I without aliasing get the same result from the query above?</p>