title: MDX problem: Source data in columns can contain square brackets ([ ]), how to stop these being interpreted as delimiters?
body: <p>I am working on a project that is using OLAP cubes, and we have a problem with an MDX statement. </p>
  
  <p>The problem is that our source data has square brackets in. For example:
  Customer [customer code]</p>
  
  <p>This is an example query on a specific customer, whose name is "CustomerA [123]". The measures list is insignificant and has been left out:</p>
  
  <pre><code>SELECT &lt;measures&gt; ON COLUMNS, 
  [Customer_Dim].[All Customer_Dim].[CustomerA [123]] ON ROWS
  FROM [cubename]
  </code></pre>
  
  <p>So when we submit this query for one specific customer, the MDX uses those square brackets as delimiters.</p>
  
  <p>This causes an error, because it is reading the [123] and thinks there is a syntax error.</p>
  
  <p>We want to protect the square brackets from the data from being read as delimiters. Is there a way to shield them, or are we forced to change the character to something else?</p>
  
  <p>Thanks</p>