Designing Report Models: How-to Topics

Using Model Designer, you can generate models based on SQL Server relational databases. Using Report Manager, you can generate models based on SQL Server relational databases, SQL Server 2005 or later Analysis Services dimensional databases (cubes), Oracle databases running version 9.2.0.3 or later, or Teradata databases running versions v12 or v6.2. Model Designer can be used to modify models based on SQL Server relational databases regardless of the tool used to generate them.

This section contains step-by-step instructions for generating models, customizing clickthrough reports, and performing tasks in Model Designer.