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 220.127.116.11 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.