Howto upload programaticaly SMDL file&

Earlier, if you wanted to deploy a report file (*.rdl), you just need to go to Report Manager, and upload the *.rdl file.

Things wont work like that with model files (*.smdl). If you try to just upload a model file, you will get the following error:

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

So you need to have the information about data source view inside your model file.

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.

All these steps can be done programmatically by using Reporting Services web service.

repService.CreateModel(destFileName, "/" + destFolderName, fileDefinition, arrProperty);

U might have to use CreateDataSource to attach a data source.

Hi,

I am confused about the step of " copying the code from .dsv file and then pasting into the .smdl file". how can I avoid this manual step ?

Please let me know

Regards,

bala

Once you upload the report model to the server, you must call the SetItemDataSources() web service to set the data source on your report model.