Tutorial: Creating a Report Model Based on an Analysis Services Cube

New: 5 December 2005

You can create report models based on SQL Server databases or SQL Server Analysis Services (SSAS) database cubes and then use the resulting model in Report Builder. To create a model from a SQL Server database, you can use Report Manager, Management Studio or Model Designer. For more information about creating models using Model Designer, see Tutorial: Creating a Report Model and Tutorial: Refining a Report Model in Model Designer.

To create a model from a SQL Server Analysis Services cube, you must use Report Manager or Management Studio. Model Designer cannot be used to create models from cubes, and a cube-based model cannot be modified in Model Designer afterwards.

In this tutorial, you will learn how to create an Analysis Services cube-based model using Report Manager and Management Studio. For the purposes of this tutorial, you will create two report models based on an SSAS cube; however, you can follow these same steps, with the modifications noted, to create a model based on a SQL Server database.


The sample databases are not installed automatically during setup, but you can install them at any time. For information about installing the samples, see Installing Samples.


To use this tutorial, your system must have the following installed:

  • Microsoft SQL Server 2005 Reporting Services running in native mode. Support for models is not available in SQL Server Express Editions. For more information, see Features Supported by the Editions of SQL Server 2005.
  • Microsoft SQL Server 2005 Analysis Services.
  • SQL Server 2005 Management Studio.
  • SQL Server 2005 Business Intelligence Development Studio.
  • SQL Server 2005 with the AdventureWorks DW sample database.

In addition, you must have the following permissions:

  • To deploy and publish the report model, you need to be assigned to the Content Manager or Publisher role.
  • Permissions to retrieve data from the AdventureWorks DW database.


Lesson 1: Deploying the Analysis Services Database

Lesson 2: Creating a Report Model Using Report Manager

Lesson 3: Creating a Report Model Using Management Studio

See Also

Other Resources

Developing Analysis Services Solutions and Projects
Introducing SQL Server Management Studio
Introducing Business Intelligence Development Studio
Introduction to Solutions, Projects, and Items
Generating Models Using Report Management Tools
Working with Report Builder (Ad Hoc Reports)
Managing Permissions and Security for Reporting Services

Help and Information

Getting SQL Server 2005 Assistance