Process everything except for a few partitions

Category: sql server analysisservices


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="">
    <Process xmlns:xsd="http://www.w3....">

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?



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.