I'm in the process of creating a large cube. The source data is
partitioned by week so I've partitioned the cube the same way (each
weekly table is the fact table for a partition). All the dimensions,
storage design, etc. are the same for all 53 partitions. The idea is to
process the current week only on a daily basis since the data in
previous week's partitions does not change.

The problem I'm having is that I can't seem to process partitions
without wiping out previously processed partitions. For example, if I
have previously processed Weeks 24 and 25, then do a Full Process on 26
and 27, Weeks 24 and 25 show up as Not Processed (and their data is
gone). It's as if AS considers the Full Process to have applied to the
entire cube, not just the partitions in question.

I tried processing the entire cube first (with small fact tables so it
would finish in a reasonable amount of time), then doing incremental
updates on the partitions in question, but at the end of the process it
says it can't merge the partitions because the destination partition
needs to be processed first.

Any help would be appreciated.

--
Randy Knight
Senior Database Engineer
Match.com


Posted via http://dbforums.com

One problem with partition processing, that has been discussed earlier
in this newsgroup, is the automatic processing of private dimensions,
which invalidates any previously processed partitions. If you have
private dimensions in your partitioned cube, try making them shared.

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!