MS SQL Server OLAP - Partitioning

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Partitioning

Jim_OLAP

2005-08-29, 8:25 pm

All,

I have developed a cube with multiple partitions using DSO using the
following steps --

1) Created a dummy partition with aggregations, but no real data
2) Used the *Clone* command to create new partitions based off of that dummy
partition

The partitions get created O.K, but my question is does using *Clone* also
clone the dummy aggregations, or do you need to use the
keyword *CloneMinorChildren * to get the aggregations as well.

On the same thought, is there a way to easily check that a partition has
aggregations?

Very interested,

Jim

Sponsored Links