Hands-On Procedure
Preparation
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:
DBJ_STORDESIGN
The Duplicate
Name dialog appears, with our modification, as depicted in Illustration
5.
Illustration 5: The
Duplicate Name Dialog, New Name Inserted
TIP:
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.