Model Designer

Model Designer is a Reporting Services tool used within the Business Intelligence Development Studio to define, edit, and publish report models that are used in Report Builder. A report model is a business description of the underlying database. It describes the data in terms of entities, attributes, and relationships (roles), which can then be used by Report Builder users to help them build ad hoc reports. The model describes the underlying database in familiar business terms that end-users can understand. You can launch Model Designer and start designing a model directly using a data source or you can automatically generate a model using a predefined set of rules. Model Designer can generate models that are based on SQL Server 2000 and 2005 databases and Oracle databases running version 9.2.0.3 or later. For information about models generated from Analysis Services cubes, see Generating Models Using Report Management Tools.

To see a tutorial about creating a report model project, see Tutorial: Creating a Report Model.

See Also

Concepts

Report Builder
Working with Model Designer
Model Designer Object Properties
Data Sources Supported by Reporting Services

Other Resources

Report Model Designer Wizard F1 Help
Introducing Business Intelligence Development Studio

Help and Information

Getting SQL Server 2005 Assistance

Change History