Preparation
Create a New
Analysis Services Project within a New Solution
For purposes of our
practice session, we will create a copy of the Adventure Works Analysis
Services project, one of several samples that are available with (albeit
installed separately from) the Microsoft SQL Server 2005 integrated
business intelligence solution. Creating a "clone" of the project
means we can make changes to select contents (perhaps as a part of later exploration
with our independent solution), while retaining the original sample in a
pristine state for other purposes, such as using it to accompany relevant
sections of the Books Online, and other documentation, as a part of
learning more about Analysis Services and other components of the
Microsoft integrated business intelligence solution in general.
To
begin, we'll 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 sample project folder.
Two versions of the Adventure Works Analysis
Services project samples are installed, by default (and, of course, subject
to be installed in a different location (or locations) on our individual
machines), in the following location
C:\Program
Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services
Project
Of the two samples, we will select the Enterprise project, as it is a more evolved
sample than the Standard project. We will copy the Enterprise folder to another location, and
work with it within our practice session. (If the Standard project is
all that is available in the local environment, use that instead.)
7.
Right-click
the Enterprise 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
Enterprise 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 a "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: Pasting
the Copy of the Enterprise Project Folder in a Selected Location
The Enterprise folder appears, via the Open
Project dialog, in the new location, as depicted in Illustration 5.
Illustration 5: Enterprise
Project Folder in Its New Location ...
12. Right-click the Enterprise 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:
RS032 Simple KPIs in RS
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, Adventure Works.sln, and the project
file, Adventure Works DW.dwproj, appear at this point, along with two
folders containing associated objects.
18. Select the Adventure Works.sln file,
and then click the Open button, as shown in Illustration 8.
Illustration 8: Opening
the Adventure Works.sln File
The Adventure
Works solution opens, complete with Adventure Works DW Analysis Services
project, and we see the various associated objects appear in Solution
Explorer, as depicted in Illustration 9.
Illustration 9: The New
Solution, Project and Objects within the Solution Explorer
19. Right-click the Adventure Works solution, within the Solution Explorer.
20.
Select Rename
from the context menu that appears, as shown in Illustration 10.
Illustration 10:
Renaming the Solution ...
21. Type the following replacement
name into the solution's activated caption box:
RS032_Adventure Works
22. Click outside the caption box to
accept the new name.
23. Right-click the Adventure Works
DW Project,
underneath the newly renamed solution, within the Solution Explorer.
24.
Select Rename
from the context menu that appears, as depicted in Illustration 11.
Illustration 11:
Renaming the Analysis Services Project ...
25. Type the following replacement
name into the project's activated caption box:
RS032_Adventure Works DW
26. Click outside the caption box to
accept the new name.
27. Click Yes on the dialog box
that appears next, asking if we would like to change the object name as well,
as shown in Illustration 12.
Illustration 12: Click Yes
to Change the Object Name, As Well ...
The newly renamed solution and project appear within the Solution
Explorer, as depicted in Illustration 13.
Illustration 13: The
Newly Renamed Solution and Project Appear ...
» 
Comment and Contribute
