I have a scenario where I have 3 different cubes.e.g. lets say cube 1 holds data for current Month, cube 2 holds data for current year (2007) and cube 3 holds data for Next Year (2008).
Data from DSO daily loads to Current Month Cube, at the end of each month data would be deleted from "Current Month Cube" and dumped to "Current Year Cube (2007)".
In next year 2008, at the end of each month data would be deleted from "Current Month Cube" and dumped to "Next Year Cube (2008)".
For the year 2009, (delete 2007 data and load 2009), and for the year 2010, (delete 2008 data and load 2010).
This process should be automated i.e. which cube to load should be done auto.
Any ideas would be highly appreciated.
Thanks in advance,