Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Aug 21, 2006

Mastering OLAP Reporting: Prototype KPIs in Reporting Services - Page 2

By William Pearson

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 ...



MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM


















Thanks for your registration, follow us on our social networks to keep up-to-date