title: SQL Analysis Services - query cannot be processed
body: <p>I am running Analysis Services, added a dimension to the mix and now I cannot browse the cube. </p>
  
  <p>Browsing cube with Sql mgmt says there is an unknown error, running an MDX query in SQL Mgmt returns a value on one measure and null on other measures.</p>
  
  <p>How do I go the next level to work out what it is hitting in SQL? Can I run a SQL Profile (not an MDX profile but standard SQL) and look at the call? I tried this but cannot work out what event to profile.</p>
  
  <p>or How do I determine why a null is getting returned for a measure?</p>