how to delete multiple ssas database using xmla script

Question

how to delete multiple SSAS database using XMLA script

if possible please post me with syntax

Answer 1

You can combine multiple XMLA commands in a batch tag, try something like this:

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine" Transaction="true">
<Delete xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
      <Object> 
          <DatabaseID>DB1</DatabaseID>
      </Object>
</Delete>
<Delete xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
     <Object> 
         <DatabaseID>DB2</DatabaseID>
     </Object>
</Delete>
</Batch>