Scripting a Cube in XMLA

Perform a straight database migration from SSAS 2000 by using the Migration Wizard. The new database is probably named "FoodMart 2000."

Create a new FoodMart database, named something like "FoodMart 2005."

Script and run the data source from the migrated database (change the database in the script).

Script and run the DSV from the migrated database (change the database in the script).

Add the appropriate relationships and primary keys to the DSV in FoodMart 2005.

Rename named calculations in the FoodMart 2005 DSV as appropriate. The Migration Wizard added some named calculations to some of the tables in the DSV and named them "Column1." These named calculations reflect SQL statements that were entered into the Source Column for cube measures or Member Column for dimension-level names in FoodMart 2000. It's a good idea to rename these to better represent the underlying calculation.

Create a new cube in FoodMart 2005 by using the Auto Build feature.

Review and revise the resulting dimensions (e.g., attribute properties, user hierarchies, attribute relationships) in FoodMart 2005.

Script and run the XMLA to create other objects, such as partitions, MDX calculations, and actions to copy them from the migrated database to FoodMart 2005. You can script these objects independently or extract them from a cube or database creation script.

Add designations for parent/child, custom member formulas/rollups, and unary operators to FoodMart 2005. You can determine these designations by reviewing the migrated database.

Add drillthrough actions to duplicate drillthrough settings from SSAS 2000.