title: Moving a SQL 2000 cube to SQL 2005
body: <p>I have been tasked with moving a cube which is in SQL 2000 to SQL 2005.  It would appear that the Dimensions and Measures are all coming from one table.  Is this possible in SQL 2005 or do I need to restructure the data into multiple Dim/Fact tables, and is there any way to easily move a SQL 2000 cube into SQL 2005?</p>