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 folders 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 projects 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:
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