Processing SSAS cube through XMLA

Question

I have little knowledge on SSAS cube processing through XMLA code and would need help here. I am processing the cube through below code.

<Object>
  <DatabaseID>DB_test</DatabaseID>
  <CubeID>Test</CubeID>
  <MeasureGroupID>Order</MeasureGroupID>
  <PartitionID>Order 1</PartitionID>

ProcessFull UseExisting

So I wanted to know if this code only process partition as the hierarchy that I am giving is Cube --> MeasureGroup --> partition.

If so, what should I need to do process full cube, do I need to add something like below to my query.

<object>    
  <DatabaseID>DB_test</DatabaseID>
  <CubeID>Test</CubeID>
</Object>
<Type>ProcessFull</Type>

GregGalloway GregGalloway · Accepted Answer · 2016-01-21T01:23:23

I would start by reading this great whitepaper.

You are correct about the XMLA needed to ProcessFull your cube object but that won't process any dimensions.

If the following is fast enough then just do a ProcessFull on the database (which processes dimensions and cubes):

<Batch Transaction="true" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <Process>
    <Object>
      <DatabaseID>DB_test</DatabaseID>
    </Object>
    <Type>ProcessFull</Type>
  </Process>
</Batch>

Processing SSAS cube through XMLA

1 Answers