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