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 9.2.0.3 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.
In This Section
- 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)
See Also
Concepts
Working 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