Procedure: Make a Copy of a Basic Analysis Services Sample Project within a New Solution
Objective:
Use
this procedure to create a copy of the sample tutorial Analysis Services
Project that ships with MSSQL Server 2005 Analysis Services.
NOTE:
The tutorial samples do not self-install, and are designed to accompany various
MSSQL Server 2005 application tutorials that appear on the installation
media, as well as online at www.microsoft.com.
The
focus of this procedure is to make a copy of the more basic Analysis
Services project, which we will then deploy and use as a rudimentary database
(containing a cube, from within which we can perform various practice exercises
without the distractions that accompany the much more sophisticated Adventure Works DW database that ships with Analysis
Services 2005. The Adventure Works DW database is typically
installed during the initial installation of MSSQL Server 2005 and
components (or shortly thereafter), along with various other samples for use
throughout the application suite.
To
begin, launch the SQL
Server Business Intelligence Development Studio.
1.
Click Start.
2.
Navigate to,
and click, the SQL
Server Business Intelligence Development Studio, as appropriate.
The
equivalent on my PC appears as depicted in Illustration 1.
Illustration 1:
Launching SQL Server Business Intelligence Development Studio
We
briefly see a splash page that lists the components installed on the PC, and
then Visual Studio .NET 2005 opens at the Start page.
3.
Close the Start
page, if desired.
4.
Select File
-à Open from the main menu.
5.
Click Project
/ Solution ... from the cascading menu, as shown in Illustration 2.
Illustration 2:
Selecting a Project ...
The Open
Project dialog appears.
6.
Browse to the
location of the Adventure Works Analysis Services tutorial sample
project folders.
Two versions of the Adventure Works Analysis
Services tutorial project samples should be present. By default (and, of
course, subject to be installed in different locations on our individual
machines), the tutorial samples appear in the following location
C:\Program
Files\Microsoft SQL Server\90\Samples\Analysis Services\Tutorials\
Of the two samples, named Lesson 4 and Lesson 7,
we will select the Lesson 4 project, as it contains the UDM for a
rudimentary database and cube (the Lesson 7 project is enhanced, and
represents the work accomplished through later chapters of the tutorial. Both
projects exist to allow students to “pick up” at points in the tutorial - at Lesson
4 or Lesson 7 – without being required to have completed all steps
of the tutorial to get to that given point.)
7.
Right-click
the Lesson 4 folder, containing the sample Adventure Works solution,
project and associated objects.
8.
Select Copy
from the context menu that appears, as depicted in Illustration 3.
Illustration 3: Copy the
Basic Analysis Services Project Folder ...
9.
Navigate, from
within the Open Project dialog box, to the location of preference for
storing the folder we have copied, and from which we will create our “clone”
project.
10. Upon arrival within the desired
folder, right-click the area within the folder.
11.
Select Paste
from the context menu that appears, as shown in Illustration 4.
Illustration 4: Paste
the Copy of the Basic Analysis Services Project to a Selected Location
The Lesson
4 folder appears, via the Open Project dialog, in the new
location, as depicted in Illustration 5.
Illustration 5: Basic
Analysis Services Project in Its New Location ...
12. Right-click the Lesson 4
folder, within the Open Project dialog.
13.
Select Rename
from the context menu that appears, as shown in Illustration 6.
Illustration 6: Renaming
the Folder ...
14. Type the following replacement
name into the folder’s activated caption box:
DBJ_Basic Analysis Services Project
15. Click outside the caption box to
accept the new name, which then appears as depicted in Illustration 7.
Illustration 7: Newly
Named Folder ...
16. Click the new folder, to select
it.
17. Click the Open button on
the Open Project dialog.
The solution file, Analysis Services Tutorial.sln,
appears at this point, along with a folder containing the associated objects.
18. Select the Analysis Services
Tutorial.sln file, and then click the Open button, as shown in Illustration 8.
Illustration 8: Opening
the Adventure Works.sln File
The Analysis
Services Tutorial solution opens, and we see the various associated objects
appear in Solution Explorer, as depicted in Illustration 9.
Illustration 9: The
Cloned Project and Objects, within the Solution Explorer
19. Right-click the Analysis Services
Tutorial Project,
within the Solution
Explorer.
20.
Select Rename
from the context menu that appears.
21. Type the following replacement
name into the project’s activated caption box:
DBJ_Basic A S Project
22. Click outside the caption box to
accept the new name.
23. Click Yes on the dialog box
that appears next, asking if we would like to change the object name, as well.
24. In like manner, rename the
solution atop the tree to the following:
DBJ_Basic A S Solution
25. Finally, rename the cube within
the project from Analysis
Services Tutorial.cube to the following:
Basic.cube
26. Click Yes on the dialog box
that appears next, asking if we would like to change the object name, as well.
The newly
renamed objects appear within the Solution Explorer, as shown in Illustration
10.
Illustration 10: The
Newly Renamed Objects Appear ...
As a final step, we will modify the targeted database, to
prevent overwrite of the existing (if it has, indeed, already been deployed in
your environment) Lesson 4 Analysis Services Tutorial sample database on
the Analysis Server (to preserve it for working directly with the
tutorials that come with Analysis Services 2005 and other uses).
27. Right-click the new project, DBJ_Basic
A S Project, within the Solution Explorer.
28. Select Properties from the
context menu that appears, as depicted in Illustration 11.
Illustration 11: Select
Properties for the Project
The DBJ_Basic
A S Project Properties Pages dialog opens.
29. Click Deployment, under Configuration
Properties, in the tree in the left-hand pane of the dialog.
30. Replace the current text (Analysis
Services Tutorial), as appropriate, in the Database box (in the
lower right half of the dialog, within the Target properties group) with
the following:
DBJ_Basic AS DB
31. Adjust the Server name, as
appropriate, while within the Target properties group subsection of the Deployment
section of the Configuration Properties.
The newly renamed Target Database (and Server,
as appropriate) appears within the DBJ_Basic A S Project Properties Pages
dialog, as shown in Illustration 12.
Illustration 12: The
Newly Renamed Target Properties
» 
Comment and Contribute
