Once you have design the report model and build the project this is the time to deploy on production environment. Similar to Report deployment if you will specify the Report Server and the folder name where your want to deploy the project and deploy; Visual studio environment deploy the project on the report server. But in case it is not possible then have to deploy the Report model through Report Manager Web application (using upload feature of web manager).
Connect to the Target server -> Open Report Manager -> Locate the folder where you want to deploy the Report Model -> Click on Upload File Button of Report Manager
Locate the Report Model (.smdl) file and click Ok. It will deploy the file on the server.
Wait a minute are you getting a problem “The DataSourceView is missing for the SemanticModel” or something it just because of data source view is not available.
The data source view and report model are the xml based file so you need to merge the both file (.smdl and .dsv) in one and then upload the file you wont get any error.
These are the steps to merge the .dsv file in report model (.smdl)
Open data source view in editor and copy all contains of the file (Ctrl + A) and (Ctrl + C).
Open Report Model (.smdl) file in another instance of editor and locate the (</Entities>) bottom line of the file.
</Entities>
Paste contains of DSV file here
</SemanticModel>
Save the file and close the editor.
Now Report Model is ready to deploy. Upload the Report model on Report Manager
Edit the Report Model and Set the Appropriate Data Set (.ds)
Connect to the Target server -> Open Report Manager -> Locate the folder where you want to deploy the Report Model -> Click on Upload File Button of Report Manager
Locate the Report Model (.smdl) file and click Ok. It will deploy the file on the server.
Wait a minute are you getting a problem “The DataSourceView is missing for the SemanticModel” or something it just because of data source view is not available.
The data source view and report model are the xml based file so you need to merge the both file (.smdl and .dsv) in one and then upload the file you wont get any error.
These are the steps to merge the .dsv file in report model (.smdl)
Open data source view in editor and copy all contains of the file (Ctrl + A) and (Ctrl + C).
Open Report Model (.smdl) file in another instance of editor and locate the (</Entities>) bottom line of the file.
</Entities>
Paste contains of DSV file here
</SemanticModel>
Save the file and close the editor.
Now Report Model is ready to deploy. Upload the Report model on Report Manager
Edit the Report Model and Set the Appropriate Data Set (.ds)
Comments