Hello,

I'm looking for ideas here. We have a cube with both a history
partition (older than a month) and a current partition. The history
partition goes back a very long way, and the cube takes too long to
process. Plus, for the older data, we really don't need ALL the
details. Just the Time , maybe 1 more dimension, and all the measures
would be fine.

Is there a way to do this - create another partition, for OLD history,
and limit it somehow so that cube processing is much quicker, since
having a more limited set of dimensions is okay?

Thanks for any ideas!

Sylvia

All partitions of a cube share the same dimensionality of that cube.
You only possible solution here is to create two physical cubes and then
create a virtual cube across all of the share dimensions. Whether or not
this will capture all of the semantics you require, depends. Give it a try
and see. It is pretty straightforward to implement.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Sylvia" <Puget4753 (AT) yahoo (DOT) com> wrote