SQL SErver 2000 OLAP

Currently, I have a sales cube that's been rebuilt every night. It contains
data from 2000 to 2006. I would like to seperate this cube into two cubes:
Hist_Sales and Curr_Sales. I only need to rebuild the curr_sales cube every
night. Also, I would like to have a virture cube to bring these two cubes
together.

What I am thinking is
1. make a copy of sales cube and name it Hist_Sales
2. remove 2006 data from underline sql tables
3. build Hist_sales cube

4. remove history data and add 2006 data for the underline sql tables
5. build Curr_sales cube

The problem with this approach is that there is no way to build the virture
cube because the shared dimention only has data for Curr_sales cube.

How should I get this done?

Why not use separate history and current partitions of the same cube -
as long as dimensions only need to be incrementally processed?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***