SSAS multidimensional cube - parallel processing of partitions

Question

I have one multidimensional cube that have just one fact table with 2 partitions. I run the processing and when I looked in Process Progress window, I saw that only one partition has been processed, and other is waiting. And somehow I expected that it will process both partitions in parallel.

Am I missing something, or it just works that way by default. Should I do something to force parallel processing in order to speed it up?

Thanks!

userfl89 userfl89 · Accepted Answer · 2019-02-21T17:46:41

How are you sending the processing request? Try using an XMLA script with the Parallel option as outlined below.

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
    <Parallel>
        <Process>
            <Object>
                <DatabaseID>Your Cube</DatabaseID>
                <CubeID>Your Cube</CubeID>
                <MeasureGroupID>Fact Table</MeasureGroupID>
                <PartitionID>Fact_Table_Partition_1</PartitionID>
            </Object>
            <Type>ProcessFull</Type>
        </Process>
        <Process>
            <Object>
                <DatabaseID>Your Cube</DatabaseID>
                <CubeID>Your Cube</CubeID>
                <MeasureGroupID>Fact Table</MeasureGroupID>
                <PartitionID>Fact_Table_Partition_2</PartitionID>
            </Object>
            <Type>ProcessFull</Type>
        </Process>
    </Parallel>
</Batch>

SSAS multidimensional cube - parallel processing of partitions

1 Answers