title: Member was not found in the cube when the string was parsed
body: <p>I'm working in an application where I have a database table with member values but, it could be that there aren't the same members in the database that in the cube. For example:</p>
  
  <p>DATABASE:</p>
  
  <ul>
  <li>AverageSpeed </li>
  <li>AverageTime  </li>
  <li><strong>AverageDistance</strong></li>
  </ul>
  
  <p>CUBE:</p>
  
  <ul>
  <li>AverageSpeed</li>
  <li>AverageTime </li>
  </ul>
  
  <p>My MDX is something like this:</p>
  
  <pre><code>WITH   MEMBER [IDENTIFIER] AS [Measures].[AverageDistance]
  MEMBER [DateYear] AS 
  'ANCESTOR( [DimDate].[All DimDate].CurrentMember,[DimDate].[All DimDate].CurrentMember.Level.Ordinal -1).Member_Key'
  MEMBER [DateMonth] AS 
  'ANCESTOR( [DimDate].[All DimDate].CurrentMember,[DimDate].[All DimDate].CurrentMember.Level.Ordinal -2).Member_Key'
  MEMBER [DateDay] AS 
  'ANCESTOR( [DimDate].[All DimDate].CurrentMember,[DimDate].[All DimFecha].CurrentMember.Level.Ordinal -3).Member_Key' 
  SET [COLUMNS] as ' {[DateYear],[DateMonth],[DateDay],[DateDay]} '         
  SET [IDENTIFIERS] as ' {[IDENTIFIER]} '                  
  SELECT { [DimDate].[All DimDate].[All] } ON ROWS,                
  { [COLUMNS] + [IDENTIFIERS] } ON COLUMNS  
  FROM ( select {[DimDate].[All DimDate].[Day].&amp;[20100401]:[DimDate].[All DimDate].[Day].&amp;[20180628] }      
  on 0 from  [CUBE])         
  WHERE ( [DimPlace].[Place].&amp;[000001] )
  </code></pre>
  
  <p>When I execute the query it gives me the next error:</p>
  
  <ul>
  <li>The '[AverageDistance]' member was not found in the cube when the
  string, [Measures].[AverageDistance], was parsed.</li>
  </ul>
  
  <p>I want to return null if the member doesn't exist.</p>
  
  <p>I know I can use ISERROR(), but I just want the null value if the member <strong>doesn't exist</strong>, if there is other error I have to show it to the user. </p>
  
  <p>Is there a way to achieve this from the MDX query? </p>