Why not try to use XMLA command directly

  When you build a MSAS project in BIDS, you want to test it. Normally MDX statement can met with the requirements, but maybe you can use XMLA command directly. Let me make a simple example. I create a project, and make one dimension write enable and add some calculated measures. I ever used XMLA command to test, even thought I can test by MDX statement. Below is some test scripts.

<Insert xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <Object>
    <Database xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">TestComment</Database>
    <Cube>Test2 Cube</Cube>
    <Dimension>Comment</Dimension>
  </Object>
  <Attributes>
    <Attribute>
      <AttributeName>Comment</AttributeName>
      <Keys>
        <Key>1000#;2005;5</Key>
      </Keys>
      <Value>Super Super Test</Value>
    </Attribute>
  </Attributes>
</Insert>

<Update xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <Object>
    <Database xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">TestComment</Database>
    <Cube>Test2 Cube</Cube>
    <Dimension>Comment</Dimension>
  </Object>
  <Attributes>
    <Attribute>
      <AttributeName>Comment</AttributeName>
      <Value>Update XMLA Command</Value>
    </Attribute>
  </Attributes>
  <Where>
      <Attribute>
        <AttributeName>Comment</AttributeName>
        <Keys>
          <Key>1000#;2005;5</Key>
        </Keys>
      </Attribute>
  </Where>
</Update>