Tutorial: Refining a Report Model in Model Designer
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.
ConceptsReporting Services Tutorials
Other ResourcesWorking with Model Designer
Managing Permissions and Security for Reporting Services