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
Expand the Analysis
Servers folder by clicking the "+" sign to its immediate
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
Expand the FoodMart
Expand the Cubes
sample cubes appear,
as shown in Illustration 2.
Illustration 2: FoodMart
2000 Database Sample Cubes
the HR sample cube.
from the context menu that appears, as shown in Illustration 3.
Illustration 3: Selecting
Copy from the Context Menu
the Cubes folder.
from the context menu that appears, as shown in Illustration 4.
Illustration 4: Selecting
Paste from the Context Menu
Name dialog appears.
have two cubes of the same name in a given MSAS database.
following into the Name box of the Duplicate Name dialog:
Name dialog appears, with our modification, as depicted in Illustration
Illustration 5: The
Duplicate Name Dialog, New Name Inserted
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
to save the name change.
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.