Tutorial: Refining a Report Model in Model Designer

New: 5 December 2005

This tutorial is designed to help you fine-tune a report model that was generated using Model Designer. By following this tutorial, you will better understand how these refinements affect the client reporting experience.

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.
  • SQL Server 2005 with the AdventureWorks sample database.
  • SQL Server 2005 Business Intelligence Development Studio.

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.
  • To retrieve data from the AdventureWorks database.

Community Additions