Report Modeling How-to Topics
Using Model Designer, you can generate models based on SQL Server 2000 and 2005 relational databases, Oracle databases running version 18.104.22.168 or later versions, and Teradata databases that runs version 12.00 or 6.20.
Using Management Studio, you can generate models based on SQL Server 2005 relational databases or SQL Server 2005 Analysis Services dimensional databases (cubes).
Using Report Manager, you can generate models based on SQL Server 2005 relational databases, SQL Server 2005 Analysis Services dimensional databases (cubes), or Teradata databases.
Model Designer can be used to modify models based on SQL Server 2005 relational databases and Teradata databases regardless of the tool that is used to generate them.
This section contains step-by-step instructions for generating models, customizing clickthrough reports, and performing tasks in Model Designer.
How to: Create a Model Using Report Manager
How to: Create a Model Using Management Studio
How to: Create a Teradata Data Source File for a Report Model Project
How to: Create a Report Model with Primary Keys from a Teradata Database
How to: Link a Report to a Model as a Clickthrough Report
Model Designer How-to Topics
How to: Generate Report Models (SharePoint Integrated Mode)
ConceptsWorking with Models
Working with Model Designer
Generating Models Using Report Management Tools
Working with Report Model Query Designer
Working with Report Builder (Ad Hoc Reports)
Report Builder How-to Topics
Model Designer Object Properties
Model Designer Query Properties