How to: Create a Report Model with Primary Keys from a Teradata Database

  • Article

New: 17 November 2008

To create a report model that automatically includes primary keys for tables and views for a Teradata database, you must generate the model in Report Manager from a shared data source that has been published to a report server.

To create and publish a shared data source for a Teradata database, see How to: Create a Teradata Data Source File for a Report Model Project.

To generate a model by using Report Manager

  1. Start Report Manager.

  2. In Report Manager, locate a shared data source for the Teradata database.

  3. Click the item to open it. The General Properties page opens.

  4. Click Generate Model. The Generate New Model page opens.

    Note

    If you do not see the Generate New Model page, work with the system administrator to ensure that the appropriate role-based security permissions have been assigned for the model. For more information, see Securing Models.

  5. Type a name for the item.

  6. (Optional) Type a description for the item.

  7. Click OK.

  8. Click Apply.

    Reporting Services generates a model for the data source. The model automatically includes primary keys.

To save the model on your computer to include in a Report Model Project

  1. In Report Manager, locate the shared data source that you created the model for in the previous procedure.

  2. Click Edit. The File Download dialog box opens.

  3. Click Save. The Save As dialog box opens.

  4. Navigate to the location on your computer where you want to save the model.

    The model is saved with the file name extension .smdl.

To view primary keys and customize the model

  1. In Business Intelligence Development Studio, open a report model project that contains a data source for the Teradata database.

  2. From the Project menu, click Add Existing Item.

  3. Browse to the saved model file, and then click Add. In Solution Explorer, the model and the data source view are added to the project. The model opens in Design view.

  4. In the Data Source Views folder, right-click the data source for the model that you imported, and then click View Designer. The data source view opens in Design view.

    Each table or view in the data source view appears on the design surface. In each table, columns that are specified as primary keys display a key symbol in front of the column name.

    For more information about primary keys, see Defining Logical Primary Keys in a Data Source View (Analysis Services) and Working with Data Source Views (Analysis Services).

    You can now customize the model as needed. After you have completed your changes, you can publish the model to the report server. For more information, see How to: Publish a Report Model [Model Designer].

See Also

Tasks

How to: Create, Delete, or Modify a Shared Data Source (Report Manager)
How to: Create a Teradata Data Source File for a Report Model Project

Concepts

Connecting to a Data Source
Generating Models Using Report Management Tools
Creating and Using Teradata-Based Report Models
Model Designer How-to Topics
Report Modeling How-to Topics
Working with Models

Other Resources

Data Source Views (Analysis Services)

Help and Information

Getting SQL Server 2005 Assistance