Export (0) Print
Expand All

Model Designer

Updated: 12 December 2006

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.

Release History

12 December 2006

Changed content:
  • Added information about Oracle databases.

Community Additions

ADD
Show:
© 2014 Microsoft