Reporting Services Report Models - Professional SQL Server 2005 Reporting Services - page 341

Reporting Services
Report Models

This chapter looks at building a Reporting Services Report Model. A Report Model is the key com-
ponent behind performing ad hoc end user queries. Using a Report Model, users can easily navi-
gate through either a SQL Server database or an Analysis Services database. To better understand
how Report Models are built and what features they include, you will do a simple walk-through
using the AdventureWorksDW database.

This chapter covers:

❑ Creating Reporting Services Report Models.

❑ Working with Report Model data sources.

❑ Creating Report Model Data Source Views.

❑ Setting Report Model properties.

❑ Deploying Report Models.

❑ Creating Report Models for Analysis Services.

Getting Started
To begin, open up the SQL Server Business Intelligence Development Studio (Development Studio
for short). In the Development Studio, you can create a number of business intelligence projects.
Go to File

➪ New ➪ Project, and select the Report Model project template as shown in Figure 8-1.