title: How to exclude a certain member from a MDX call that gets all descendants of a member at a higher level
body: <p>In an OLAP database I work with there is a 'Location' hierarchy consisting of the levels Company -> Region -> Area -> Site -> Room. I am using the following MDX to get all the descendants of a particular member at company level.</p>
  
  <pre><code>DESCENDANTS([Location].[Test Company],[Location].[Site], SELF_AND_BEFORE)
  </code></pre>
  
  <p>I now have a requirement to exclude a particular Region, named "Redundant", from the report. How can I change the above MDX to exclude this particular Region (and all its descendants)? I know this Region will be called "Redundant" but I do not want to hard-code any of the other Region names, as these may change.</p>