Introduction to MSSQL Server 2000 Analysis Services: Basic Storage Design - Page 3
September 20, 2004
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.
4. Expand the FoodMart 2000 database.
5. Expand the Cubes folder.
The sample cubes appear, as shown in Illustration 2.
6. Right-click on the HR sample cube.
7. Select Copy from the context menu that appears, as shown in Illustration 3.
8. Right-click on the Cubes folder.
9. Select Paste from the context menu that appears, as shown in Illustration 4.
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.
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.