title: mdx escape character CDE Pentaho
body: <p>I have seen some questions about MDX  escape character, but they focus on a query that has a value specified. I have a dynamic mdx, with values that will be specified by the user. This is the MDX:</p>
  
  <pre><code>    SELECT
      NON EMPTY {Hierarchize({[Measures].[INDICADOR]})} ON COLUMNS,
      NON EMPTY {Hierarchize({[NOW].[NOW].Members})} ON ROWS
      FROM [UNION_NOW]
      WHERE CrossJoin({[PARENT].[${parentParameter}]}
  </code></pre>
  
  <p>the wild card is based on my selector:</p>
  
  <pre><code>    SELECT
      NON EMPTY {Hierarchize({[NOW].[NOW].Members})} ON COLUMNS,
      NON EMPTY {Hierarchize({[PARENT].[PARENT].Members})} ON ROWS
      FROM [UNION_NOW]
  </code></pre>
  
  <p>How do I apply the "escape value" in this case?</p>