title: SSAS DMV's NOT LIKE Condition
body: <p>I have the query that runs OK on SSAS.</p>
  
  <pre><code>SELECT  DIMENSION_NAME
  FROM  $SYSTEM.MDSCHEMA_DIMENSIONS
  WHERE LEFT(CUBE_NAME,1) = '$'
  AND [DIMENSION_UNIQUE_NAME] &lt;&gt; '[Metrics]'
  AND [DIMENSION_UNIQUE_NAME] &lt;&gt; '[Measures]'
  ORDER BY DIMENSION_NAME
  </code></pre>
  
  <p>How should I specify <code>NOT LIKE</code> condition to get all <code>Dimension Names</code> that do not start with "<code>Fact</code>"? In T-SQL it is written such as </p>
  
  <pre><code>AND [DIMENSION_UNIQUE_NAME] NOT LIKE 'Fact%'
  </code></pre>
  
  <p>but how to write it in MDX?</p>
  
  <hr>
  
  <p>Edit based on comments:</p>
  
  <p>How to write the query so I can filter out elements starting with "<code>Fact</code>" in the name?</p>
  
  <p>The following query returns an error:</p>
  
  <pre><code>SELECT  DIMENSION_NAME ,*
  FROM  $SYSTEM.MDSCHEMA_DIMENSIONS
  WHERE LEFT(CUBE_NAME,1) = '$'
  AND [DIMENSION_UNIQUE_NAME] &lt;&gt; '[Metrics]'
  AND [DIMENSION_UNIQUE_NAME] &lt;&gt; '[Measures]'
  AND [DIMENSION_UNIQUE_NAME] NOT LIKE 'Fact%'
  ORDER BY DIMENSION_NAME
  </code></pre>
  
  <p>-</p>
  
  <pre><code>Executing the query ...
  Query (6, 29) The syntax for 'NOT' is incorrect.
  Execution complete
  </code></pre>