Considerations and Comments
Before we alter the
FoodMart Sales cube to support our hierarchical date prompts, we will
create a copy of the cube. Creating a clone of the sample Sales cube means
we can make changes to our cube while retaining the original sample in a
pristine state - perhaps for other purposes, such as using it to accompany
relevant sections of the Books Online, and other documentation, in
learning more about Analysis Services in general. (Once we finish with our
structural changes to the clone cube, we will create a copy of the Foodmart
Sales report, for the same reasons.)
Before we can work
with a clone of the Foodmart Sales report, we need to create a Reporting
Services project in the Visual Studio.Net 2003 Report Designer
environment. Making the enhancements to the report to add the requested
functionality can be done easily within the Reporting Services Report
Designer environment. Working with a copy of the report will allow us the
luxury of freely exploring our options, and leave us a working example of the
specific approach we took, to which we can refer in our individual business
environments. This approach also preserves the original sample in a pristine
state - for the same reasons we do so for the Sales sample cube. If you
already have a project within which you like to work with training or
development objects, you can simply skip the Create a Reporting Services
If the sample FoodMart
2000 Analysis Services database or the Foodmart Sales report was not
created / installed as part of the initial installation of the associated
application, if either was removed prior to your beginning this article, or if
either or both applications have yet to be installed, etc., see the respective Books
Online or other documentation for the necessary procedures to prepare
for the exercises that follow.
a Clone of the Foodmart Sales Cube
first create a copy of the existing FoodMart Sales cube to provide a "disposable"
Expand the Analysis
Server folder in the management console.
Expand the Analysis
Server with which you are working by clicking the "+" sign to its
Expand the FoodMart
Expand the Cubes
folder inside the FoodMart 2000 database.
the Sales cube.
from the context menu that appears, as shown in Illustration 1.
Illustration 1: Select
Copy from the Context Menu
the Cubes folder.
from the context menu that appears, as depicted in Illustration 2.
Illustration 2: Select
Paste, after Right-clicking the Cubes Folder
Name dialog appears.
Rename the new
cube as follows:
This is also a good way
to rename MSAS objects for which a "Rename" option
does not exist. 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 mean reprocessing
before the clone will be fully usable.
Name dialog appears as shown in Illustration 3.
Duplicate Name Dialog with Our Input
Click OK to
create the clone cube.
new Param_Support_Sales cube appears in the tree as depicted in Illustration
Illustration 4: The New