We will get started by
creating a new project within the Business Intelligence Development Studio,
wherein we will create a Data Source pointed to a database sample
provided with MSSQL Server 2005. This way, anyone with access to the
installed application set and its samples can complete the steps in the
a New Analysis Services Project
We begin our preparation
within Business Intelligence Development Studio, where we will create a
new Microsoft SQL Server 2005 Analysis Services (SSAS) Project.
As we have noted in other articles, those of us who have worked within earlier
versions of Reporting Services, or within the Visual Studio
development environment under other circumstances, will recognize the general
look and feel of the Studio. Under this new style of development for Analysis
Services, to which much of the documentation refers as "project
mode," we create an Analysis Services Project, which houses a
set of Analysis Services objects. The object set typically includes Data
Sources, Data Source Views, Dimensions, Cubes, and
As we have noted in other articles,
using an Analysis Services Project template affords us many
benefits, such as helping us to
and manage the items that are required to build, debug, and deploy an Analysis Services database. The
development of an Analysis
cube, a preparatory step to support our primary objectives within this session,
as well as one of the most common tasks in Analysis Services, can be accelerated though the use of the
Analysis Services 2005
Cube Wizard, which both guides and simplifies the process (as is the way of
effort to remain focused on the essentials of working with Perspectives,
we will not go into the myriad processes and structures that surround and
underlie the UDM / cube in general. As we have noted previously,
however, it is useful to make a mental note that all the objects that we create
and store within an Analysis Services project are defined as files
(using an XML representation) that eventually are deployed to an Analysis
Services database. We will see how this transpires when we deploy the
project within which we work in our practice session.
Click the Start
SQL Server 2005 within the Program group of the menu.
Server Business Intelligence Development Studio, as depicted in Illustration
Illustration 1: Opening
SQL Server Business Intelligence Development Studio
The Microsoft Visual
Studio 2005 development environment opens, beginning with the Start page,
as shown in Illustration 2.
Illustration 2: The
Start Page, Microsoft Visual Studio 2005 Development Environment (Compressed
Close the Start
-> New on the Visual Studio main
from the cascading menu, as depicted in Illustration 3.
Beginning a New Project ...
Project dialog appears.
Intelligence Projects in the Project types pane of the dialog.
Services Project in the Templates pane, as shown in Illustration
Illustration 4: Select
Analysis Services Project
templates that appear in your template pane may differ, depending upon which SQL
Server 2005 components are installed in your environment, as well as upon whether
additional templates (for Business Intelligence Projects or other types
of projects that can be created) have been defined in Visual Studio.
project Name (currently displaying a default) to the following:
The Solution Name
changes to match the project Name by default.
10. Navigate to a convenient location
to store the Project and Solution files, modifying the Location
box accordingly (Visual Studio will create a directory based upon our
The relevant section of
the New Project dialog appears similar to that depicted in Illustration
Illustration 5: The New
Project Dialog (Relevant Section), with our Input
11. Click OK to accept our input and to create
the new Analysis Services Project.
The New Project dialog
closes. Visual Studio creates the project, which appears underneath solution
ANSYS050 Perspectives, within the Solution Explorer as shown in Illustration
Illustration 6: The New
Analysis Services Project Appears
Having created a new Analysis
Services Project, we are ready to define a Data Source and Data