How to: Create a Model Using Report Manager

You can generate models from an Analysis Services cube, a SQL Server database, an Oracle database, or a Teradata database by using Report Manager. Report models are generated from shared data sources that are published on the report server. If you do not already have a shared data source, you must create one.

The report model that you generate is based entirely on the schema of the shared data source. You cannot choose which parts of the data source are included in the model, nor can you edit the rules or metadata of a generated model. However, you can set properties on the model after it is generated and define role assignments that restrict access to all or part of the model. For more information about working with shared data sources, see How to: Create, Delete, or Modify a Shared Data Source (Management Studio).


An Oracle-based model generated using Report Manager or SQL Server Management Studio will include database objects that are a part of the schema for the user account used to connect to the Oracle data source. The user account name is specified in the data source properties credentials.

To create a new data source for a report model using Report Manager

  1. In your Web browser, type the URL for your report server in the address bar.

  2. Click New Data Source.

  3. In the Name box, enter a name for the data source.

  4. Optionally, enter a brief description of the mode in the Description text box.

  5. Verify that the Enable this data source check box is selected.

  6. In the Connection type list, select the data source type to which you want to connect. The connection type must be one of the following: Oracle, Teradata, Microsoft SQL Server or Microsoft SQL Server Analysis Services.

  7. In the Connection string box, enter the connection string that points to the database.

  8. Select the connection method that Report Builder users will need to use to connect to the database.

    • Windows Authentication: Select this option when you want the operating system to authenticate SQL Server users. This option allows SQL Server to use Windows security features, such as password encryption, to authenticate users. It is strongly recommended that you select this option.

    • SQL Server Authentication: Select this option when you want users to use a SQL Server login account that you created. Users must supply a valid SQL Server login name and password.


      Whenever possible, use Windows Authentication.

  9. Click OK.

To create a report model using Report Manager

  1. In Report Manager, select the data source that you want to use for your model.

    The Properties page is displayed.

  2. Verify that you want to use the options specified for the data source.

  3. Click Generate Model.

    The General page is displayed for the data source.

  4. In the Name box, enter a name for the report model.

  5. In the Description box, enter a brief description of the model.

  6. To specify a new location to save the report model to, click Change Location.

    By default, the report model is saved to Report Manager Home.

  7. Click OK.

The report model is created and saved to the location that you specified. You can assign permissions to this model by using the SQL Server Management Studio.

See Also


Ad Hoc Reporting with Report Models
Working with Model Designer
Model Designer How-to Topics
Generating Models Using Report Management Tools
Creating and Using Cube-Based Report Models
Creating and Using Oracle-Based Report Models
Managing Permissions and Security for Reporting Services
Connecting to a Data Source
Report Modeling How-to Topics
Report Builder How-to Topics
Creating and Using Teradata-Based Report Models

Other Resources

New Data Source Page (Report Manager)

Help and Information

Getting SQL Server 2005 Assistance