Publishing a Report Model
When you are ready to deploy the model for the first time, you need to publish the entire report model project to the report server database or to the SharePoint library. When you do this, both the data source and semantic model files are published. The data source view file is combined with the semantic model file when the report model is published. As you continue to adjust the model, you can publish just the updated .smdl file.
To specify the location where the model should be published, you need to complete the information in the Model Property Pages dialog box. The following information needs to be specified.
| Target | Location |
|---|---|
TargetDataSourceFolder |
The name of the folder in which to store the published shared data sources. If you do not specify a folder, the data source is published to the same folder as the model. If the folder does not exist on the report server, Model Designer creates the folder when the model is published. When publishing to a report server running in native mode, specify the full path of the folder hierarchy starting at the root. For example, Folder1/Folder2/Folder3. When publishing to a report server running in SharePoint integrated mode, type a URL to a library or library folder. For example, http://TestServer/TestSite/Documents/DataSources. If left blank, the default is the TargetModelFolder value. |
TargetModelFolder |
The name of the folder in which to store the published model. By default, the folder is Models. If the folder does not exist on the report server, Model Designer creates the folder when the model is published. When publishing to a report server running in native mode, specify the full path of the folder hierarchy starting at the root. For example, Folder1/Folder2/Folder3. When publishing to a report server running in SharePoint integrated mode, type a URL to a library or library folder. For example, http://TestServer/TestSite/Documents. A value must be specified for this property. |
TargetServerURL |
The URL of the target report server. Before you publish a model, you must set this property to a valid report server URL. When publishing to a report server running in native mode, use the URL of the virtual directory of the report server. For example, https://server/reportserver or https://<server>/reportserver. This is the virtual directory of the report server, not Report Manager. By default, the report server is installed in a virtual directory named "reportserver". When publishing to a report server running in SharePoint integrated mode, type a URL to a SharePoint top-level site or subsite. If you do not specify a site, the default top-level site is used. For example, https://servername, https://servername/site, or https://servername/site/subsite. |
Important
To deploy a report model to a SharePoint library, you must use a URL to the library or library folder, for example, http://TestServer/TestSite/Shared Documents/.
You can modify the properties by right-clicking the report model project and selecting Properties.
If a shared data source already exists on the report server, you can publish a report model by uploading just the .smdl file to the report server or library. For more information, see Uploading Files to a Folder and Deploying Reports, Models, and Shared Data Sources to a SharePoint Site.
Note
When uploading a .smdl file from a local computer to a report server or SharePoint library, you must rebind the .smdl file to the data source file. For more information, see How to: Bind a Report or Model to a Shared Data Source.
After your model is published, you might want to assign role-based security permissions in SQL Server Management Studio. For more information, see Managing Permissions and Security for Reporting Services.
See Also
Tasks
How to: Upload Documents to a SharePoint Library (SharePoint Integrated Mode)
Concepts
Ad Hoc Reporting with Report Models
Working with Model Designer
Model Designer How-to Topics
Deploying Reports, Models, and Shared Data Sources to a SharePoint Site
Other Resources
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
12 December 2006 |
|
14 April 2006 |
|