We are using AMO to dynamically create measure group partitions. The cube
and fact table are partitioned weekly and approx. 1mil rows are being
inserted per day. On a daily basis, using another AMO script, we would like
to only process incremental updates to the current/active partition (like we
can do for dimensions using the Process Update option). This option is not
available for partitions. Is the Process Incremental option available using
AMO? If yes, can you send a code example, or can you recommend an
alternative?

Definitely. It's available.

Sample: YourPartitionName.Process(ProcessType.ProcessUpdat e)

Is this what you're looking for?





"SandyS" <SandyS (AT) discussions (DOT) microsoft.com> wrote

The ProcessType.ProcessUpdate option is not available for partitions
(according to books on-line, and I tried it anyway and an error was raised
saying the same). Also, in SSIS using the Analysis Services Processing Task,
ProcessUpdate can not be selected when the object type is Partition.

"Jesse O." wrote:

My mistake.

Have you tried processtype.processadd?




"SandyS" <SandyS (AT) discussions (DOT) microsoft.com> wrote

You can also try processtype.processdefault. This detects if a process full
is required or a process incremental. I've had one or two issues with this in
the past but it might work for you.

Rahil

"Jesse O." wrote:

To clarify: ProcessDefault will just bring an unprocessed object into a
processed state. Partitions cannot detect if they need to be re-processed
(unless you're using proactive caching).

To add rows to a partition, you should be using ProcessAdd and specifying an
out-of-line binding the defines which new rows should be added.

So your choices for partitions are:
- ProcessFull
- ProcessDefault (if the partition isn't processed)
- ProcessAdd (specifying new rows to be added)

Additionally, you can do other things like ProcessClear and ProcessIndexes,
etc but they're not relevant here...

This article has good information on this topic:

http://msdn.microsoft.com/library/de...asprocarch.asp

Thanks,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"RB" <RB (AT) discussions (DOT) microsoft.com> wrote