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.
begin, we'll launch the SQL
Server Business Intelligence Development Studio.
and click, the SQL
Server Business Intelligence Development Studio, as appropriate.
equivalent on my PC appears as depicted in Illustration 1.
Launching SQL Server Business Intelligence Development Studio
briefly see a splash page that lists the components installed on the PC, and
then Visual Studio .NET 2005 opens at the Start page.
Close the Start
page, if desired.
--> Open from the main menu.
/ Solution ... from the cascading menu, as shown in Illustration 2.
Selecting a Project ...
Project dialog appears.
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
Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services
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.)
the Enterprise folder, containing the sample Adventure
Works solution, project and associated objects.
from the context menu that appears, as depicted in Illustration 3.
Illustration 3: Copy the
Enterprise Project Folder ...
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"
10. Upon arrival within the desired
folder, right-click the area within the folder.
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
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
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
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.
from the context menu that appears, as shown in Illustration 10.
Renaming the Solution ...
21. Type the following replacement
name into the solution's activated caption box:
22. Click outside the caption box to
accept the new name.
23. Right-click the Adventure Works
underneath the newly renamed solution, within the Solution Explorer.
from the context menu that appears, as depicted in 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 ...