Hi,

I have migrated 6 physical cubes and 3 virtual cubes to MSAS 2005 from MSAS
2000 using the MigrationWizard.exe.

Phy_Cube_1; Phy_Cube_2 ; Virtual_12
Phy_Cube_3; Phy_Cube_4; Virtual_34
Phy_Cube_5; Phy_Cube_6; Virtual_56

The migration wizard created 9 regular cubes in MSAS 2005. The Virtual_12,
Virtual_34, Virtual_56 are also created like regular ones i guess pointing to
the measures / groups in the underlying physical cubes respectively.

Question 1:

Shoud i leave these cubes as it is. I mean 3 sets of cubes (2 physical, 1
dummy cube) OR Is there a better way of designing these in MSAS 2005?

Question 2:

Now that i want to creata a new cube (kind of virtual cube let's say on top
of Phy_Cube_2; Phy_Cube_3), i did not find an easy way of doing this.
Basically, i had to go & select fact tables & dimension tables from the DSV
and build the cube. I want to take advantage of the measure groups in the
existing physical cubes as the migration wizard did. Can you please let me
know the way the migration wizard achieved this?

Question 3:

As a result of migration of all these 9 cubes (with 25 dimensions each; with
10 shared dimensions) , the DSV has all of these fact & rollup tables and
became one huge diagram and not easy to manage. What is the better way of
doing this? Probably create 1 DSV per the virtual cube i migrated from MSAS
2000 to MSAS 2005.

Any thoughts?

Thanks,

Sam.