Question

pimmy23 on Thu, 14 Mar 2013 14:19:35


Hi all,

Just a quick question on processing cubes.

I'm only used to processing full cubes e.g.

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <Parallel>
    <Process xmlns:xsd="http://www.w3....">
      <Object>
        <DatabaseID>MultidimensionalProject1</DatabaseID>
      </Object>
      <Type>ProcessFull</Type>
      <WriteBackTableCreation>UseExisting</WriteBackTableCreation>
    </Process>
  </Parallel>
</Batch>

We have added partitions now and only want to process all dimensions and certain partitions.

How do I go about putting the xml to process everything except those certain partitions?

Thanks.


Sponsored



Replies

Alejandro Leguizamo on Thu, 14 Mar 2013 18:44:25


Hi pimmy:

You need to keep in mind that if you process your dimensions doing a "Full Process", you need to reprocess "Full" ALL your partitions.

pimmy23 on Fri, 15 Mar 2013 10:38:37


Hi Alejandro,

Thanks for the reply.

So what I am looking for is how to not do a full process, but a partial process on only the dims and partitions I need.

I am only familiar currently on how to do the full.

Thanks.