title: Parser: The statement dialect could not be resolved due to ambiguity
body: <p>I use <code>SSAS</code> and <code>Sql Server 2008 R2</code> .</p>
  
  <p>I write this query : </p>
  
  <pre><code>Select
  [Product].[Product Categories],[Product].[Category]
  on columns
  From [Adventure Works]
  </code></pre>
  
  <p>And I get this error :</p>
  
  <pre><code>Executing the query ...
  Parser: The statement dialect could not be resolved due to ambiguity.
  Execution complete
  </code></pre>
  
  <p>And then I use {} like this query :</p>
  
  <pre><code>Select
  {[Product].[Product Categories],[Product].[Category]}
  on columns
  From [Adventure Works]
  </code></pre>
  
  <p>And i get this error :</p>
  
  <pre><code>Executing the query ...
  Query (2, 2) Two sets specified in the  function have different dimensionality.
  Execution complete
  </code></pre>
  
  <p>Then i use this query :</p>
  
  <pre><code>Select
  ([Product].[Product Categories],[Product].[Category])
  on columns
  From [Adventure Works]
  </code></pre>
  
  <p>And i get this result :</p>
  
  <p><img src="https://i.stack.imgur.com/BTXsz.png" alt="enter image description here"></p>
  
  <p>I want get sum default measure for all product categories members </p>
  
  <p>and one columns that have total sum.</p>
  
  <p>But i need a result that have side by side columns ?</p>
  
  <p>How i can get this result ?</p>