title: Filter non empty members on row
body: <p>I have the following MDX query:</p>
  
  <pre><code>select 
      NON EMPTY [Measures].Members ON COLUMNS, 
      NON EMPTY {[MY_DIMENSION.MY_HIERARCHY].[VALUE].Members}  ON ROWS 
  from 
      [MY_CUBE] 
  </code></pre>
  
  <p>It gives the following result:</p>
  
  <pre><code>                                    [Measures].[COUNT_TICKET] 
  -------------------------------------------------------------
  [MY_DIMENSION.MY_HIERARCHY].[#null]                14 333 458  (&lt;-- not needed)
  [MY_DIMENSION.MY_HIERARCHY].[VAL1]                      4 864
  [MY_DIMENSION.MY_HIERARCHY].[VAL2]                      5 588
  [MY_DIMENSION.MY_HIERARCHY].[VAL3]                      2 567
  [MY_DIMENSION.MY_HIERARCHY].[VAL3]                      4 500
  </code></pre>
  
  <p>Which takes a long time because there are a big number of null values out there.</p>
  
  <p>Is it possible to filter the <code>#null</code> Members of my hierarchy?</p>