Step-by-Step Guide to Deploying a Report Model to Configuration Manager

Applies To: System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3

Before you can use the Create Report Wizard to create a model-based report using a custom report model, you must make the report model available from the Configuration Manager console. Use the following procedure to make a custom report model available in the Configuration Manager console.

Note

The information in this topic applies only to Configuration Manager 2007 R2 and Configuration Manager 2007 R3.

To make a custom report model available in the Configuration Manager console

  1. Locate the folder in which you created the report model project.

  2. Copy the following files from the report model project folder to a temporary folder on your computer:

    1. <Model Name> .dsv

    2. <Model Name> .smdl

  3. Open the preceding files by using a text editor, such as Notepad.

  4. In the file <Model Name>.dsv, locate the first line of the file, which reads as follows:

    <DataSourceView xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

    Edit this line to read as follows:

    <DataSourceView xmlns="http://schemas.microsoft.com/analysisservices/2003/engine" xmlns:xsi="RelationalDataSourceView">

  5. Copy the entire contents of the file to the Windows clipboard.

  6. Close the file <Model Name>.dsv.

  7. In the file <Model Name>.smdl, locate the last three lines of the file, which appear as follows:

    </Entity>

    </Entities>

    </SemanticModel>

  8. Paste the contents of the file <Model Name>.dsv directly before the last line of the file (<SemanticModel>).

  9. Save and close the file <Model Name>.smdl.

  10. Copy the file <Model Name>.smdl to the folder %programfiles%\Microsoft Configuration Manager\AdminUI\XmlStorage\Other on the Configuration Manager site server.

    Important

    After copying the report model file to the Configuration Manager site server, you must exit and restart the Configuration Manager console before you can use the report model from the Create Report Wizard.

See Also

Tasks

How to Create a New Model-Based Report in SQL Reporting Services
How to Create a New SQL-Based Report in SQL Reporting Services
Step-by-Step Guide to Creating a Report Model in SQL Reporting Services - Advanced
Step-by-Step Guide to Creating a Report Model in SQL Reporting Services - Simple
Step-by-Step Guide to Deploying a Report Model to Configuration Manager

Concepts

About Report Models in SQL Reporting Services
Administrator Checklist for SQL Reporting Services

Other Resources

SQL Reporting Services in Configuration Manager 2007 R2 and Later

For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email SMSdocs@microsoft.com.