Introduction to MSSQL Server 2000 Analysis Services: Basic Storage Design - Page 3

September 20, 2004

Hands-On Procedure


We will prepare for our practice example by opening MSAS Analysis Manager, and creating a copy of the HR cube, upon which to run the Storage Design Wizard. Keep in mind, as we progress, that we are working with a small cube with no pre-existing aggregations.

1.  Start Analysis Manager.

2.  Expand the Analysis Servers folder by clicking the "+" sign to its immediate left.

Our server(s) appear.

3.  Expand the desired server (mine appears as MOTHER1 in the illustrations).

Our database(s) appear, in much the same manner as shown in Illustration 1.

NOTE: The objects appearing in your environment will differ, in general, from mine, and depend upon the actions you have performed since initially installing MSAS.

Illustration 1: Sample Databases Displayed within Analysis Manager

4.  Expand the FoodMart 2000 database.

5.  Expand the Cubes folder.

The sample cubes appear, as shown in Illustration 2.

Illustration 2: FoodMart 2000 Database Sample Cubes

6.  Right-click on the HR sample cube.

7.  Select Copy from the context menu that appears, as shown in Illustration 3.

Illustration 3: Selecting Copy from the Context Menu

8.  Right-click on the Cubes folder.

9.  Select Paste from the context menu that appears, as shown in Illustration 4.

Illustration 4: Selecting Paste from the Context Menu

The Duplicate Name dialog appears.

We cannot have two cubes of the same name in a given MSAS database.

10.  Type the following into the Name box of the Duplicate Name dialog:


The Duplicate Name dialog appears, with our modification, as depicted in Illustration 5.

Illustration 5: The Duplicate Name Dialog, New Name Inserted


This is also a good way to rename MSAS objects for which a "Rename" option does not exist. In "rename" scenarios, we simply create the new object in the manner shown above, give it the desired name, and discard the original object, as appropriate.

Keep in mind that, in the case of cubes and other structural objects, this will likely mean reprocessing before the clone will be fully usable.

11.  Click OK to save the name change.

The new cube appears in the cube tree, among those already in place. We now have a copy of the HR cube, DBJ_STORDESIGN, upon which we can work with the Storage Design Wizard.