ProcessAffectedObjects

I have 3 partitions that are processed full seperately.

I have to place the attribute ProcessAffectedObjects="true" in my batch tag in xmla so that when one partition is processed the other objects are not removed.

This in theory works fine but the processing time is far to long. Is there any other way I could speed up the processing ofa seperate partitionwithout other objects dropping off.

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine" ProcessAffectedObjects="true">

<Parallel>

<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<Object>

<DatabaseID>PTNewBPMCube</DatabaseID>

<CubeID>BPMDSV</CubeID>

<MeasureGroupID>o C Fact</MeasureGroupID>

<PartitionID>o C Fact</PartitionID>

</Object>

<Type>ProcessFull</Type>

<ErrorConfiguration></ErrorConfiguration>

<WriteBackTableCreation>UseExisting</WriteBackTableCreation>

</Process>

</Parallel>

</Batch>

November 16th, 2007 11:09am

Hi,

you want when your partitions1 is process  partitions2 and partitions3 should work in this case instead of processed full use process Add .

Regards,

Manish

Free Windows Admin Tool Kit Click here and download it now
July 2nd, 2015 2:05am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics