Export (0) Print
Expand All

Working with Models

Updated: 17 November 2008

A report model is a metadata description of a data source and its relationships. To create reports using Report Builder, you must first build a report model based on a Microsoft SQL Server 2000 or SQL Server 2005 database, SQL Server 2005 Analysis Services cube, Oracle database running version 9.2.0.3 or later versions, or Teradata database running version 12.0 or 6.20. Models can be created by using Model Designer, Report Manager, Microsoft Office SharePoint Server 2007, or SQL Server Management Studio. Model Designer provides the most flexibility for designing models based on SQL Server or Oracle databases. By using Model Designer, you can select which rules are applied during the model generation process, and you can modify the model and its underlying data source view. By using Report Manager, Office SharePoint Server , or Management Studio, you can generate models based on SQL Server databases, Oracle databases, Teradata databases, or Analysis Services cubes. Only models based on Oracle, Teradata, and SQL Server can be further edited in Model Designer.

ms156272.note(en-US,SQL.90).gifNote:
If your model is generated from a SQL Server Analysis Services cube and the cube has been changed, you should regenerate the model. To make the Analysis Services cube-based model more efficient, it is recommended that you make your changes within the cube. For more information about the rules of model generation for AS cubes, see Creating and Using Cube-Based Report Models.

The following table presents a visual comparison between the tools available to create a report model. Models based on SQL Server databases, Oracle databases, and Teradata databases can be edited in Model Designer, regardless of which tool is used to generate the model.

Tool SQL Server Database Analysis Services Cube Oracle Database Teradata Database

Model Designer

Yes

No

Yes

Yes

Report Manager

Yes

Yes

Yes

Yes

Management Studio

Yes

Yes

Yes

No

SharePoint Server

Yes

Yes

Yes

No

Working with Model Designer

Discusses using Model Designer to create report models based on SQL Server databases.

Generating Models Using Report Management Tools

Discusses using Report Manager and Management Studio to create report models based on SQL Server databases or Analysis Services cubes.

Creating and Using Cube-Based Report Models

Discusses generating models based on Analysis Services cubes.

Creating and Using Oracle-Based Report Models

Discusses generating models based on Oracle databases.

Creating and Using Teradata-Based Report Models

Discusses generating models based on Teradata databases.

Release History

17 November 2008

Changed content:
  • Added information about Teradata databases.

12 December 2006

Changed content:
  • Added information about Oracle databases.
  • Added information about Office SharePoint Server .

14 April 2006

Changed content:
  • Added information about which versions of SQL Server models can be built from.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft