How to deploy Semantic Models manually?

Using SQL Server 2005 Business Intelligence Studio, I created a Data Source (Test.ds), Data Source View (Test.dsv), and a Report Model (Test.smdl). It is very easy to deploy this model into a Report Server, from the Business Intelligence Studio, by right clicking the Report Model Project and choosing 'Deploy'.

But how do you deploy a model file manually to the Reports Server?
When I use 'Upload File' option in Reports Manager and choose the semantic model file (Test.smdl), it gives the following error:

"The DataSourceView is missing for the SemanticModel. SemanticModel must have exactly one DataSourceView element. (MissingDataSourceView) "

I tried uploading ds and dsv and also tried merging dsv xml content into smdl. But didn't work.

A reply with how to include DataSourceView element into the model file, will be highly appreciated.Hi All,

I figured it out myself....

The report model file is an xml file containing information about the model in a language called ‘Semantic Model Definition Language’. Data source view file is also in xml format. You need to take the whole contents of the data source view (*.dsv) xml file and put it into the model file exactly after the ‘Entities’ node, ie, just before the closing tag of semantic model.

After that, you need to remove all the attributes of the node except the last one (xmlns=http://schemas.microsoft.com/analysisservices/2003/engine), and then add the xsi type attribute (xsi:type="RelationalDataSourceView").

Now you can safely upload this model file to the Report Server using Report Manager and then associate a data source to make it work.|||This has to be done manually with cutting and pasting? Is there an easier way?|||Your xsi syntax is slightly incorrect. The valid attribute syntax is:

xmlns:xsi="RelationalDataSourceView"

Combining this with your previous instruction yeilds the following element declaration:
<DataSourceView xmlns="http://schemas.microsoft.com/analysisservices/2003/engine" xmlns:xsi="RelationalDataSourceView">|||

The tool that helps me out is located at http://www.sqldbatips.com/showarticle.asp?ID=62. It creates the scripts and you can tweak them to do single deployments for any model component.

R

|||

None of this is working. when i try to save the model it asks me to save twice. then when i go back to smdl file i dont the changes, i see the old smdl that i had before pasting the datasourview node.