Deployment of Reports and Data Sources

What is the best way to deploy reports to production considering the fact that different developers would be working on different reports and different data sources. Also consider that the data sources connect to local machines of the developers during report creation and a different database server on deployment.

One way is to use VS2005 to deploy it to production but I am not sure if that is the way to go?

Any ideas?

Thanks

I'd probably create an RSS script which will publish the report to the whatever server it needs to and then actually "fixes up" the report to point to a "production datasource" which already exists on the production box. This "production datasource" points to the correct database on the server.

Use the CreateReport() API to publish the report, and here's a quick sample on fixing up the datasource on a report:

DataSourceReference reference = new DataSourceReference();
DataSource[] dsarray = new DataSource[1];
DataSource ds = new DataSource();
reference.Reference = "/Data Sources/AdventureWorks";
ds.Item = (DataSourceReference)reference;
ds.Name = "AdventureWorks";
dsarray[0] = ds;
rs.SetItemDataSources("/AdventureWorks Sample Reports/Company Sales", dsarray)

It bascially sets the datasource of the Company Sales report to point to the AdventureWorks datasource int he /Data Sources folder.

The nice thing about this idea is that if you have only a few different databases to deal with, you could actually write the RSS script to that it acts on all reports in filesystem folder, and then does some thinking and points each report to the correct "production" data source during the "fix up" phase...

Deploying Analysis Service Project give me error

Error in the OLAP storage engine: I am new to Analysis Service.

I have one fact table and six dimensions.

It give me error

An error occurred while processing the ACTUALSALES partition of the ACTUALSALES measure group for the 'SALES DW' cube from the Analysis service Project database.

Please help.

Thank you

Biju Varughese

When you process the cube you can see information about each step in processing. If you mark the error message and click details you will see a more detailed error message. Can you paste that message to the group?

Without knowing the details of your problem you can try a manual full processing of each dimension i BI-Dev-Studio and process the cube after that.

If this is not working you can tell us if you have the source database on the same machine as SSAS 2005?

Regards

Thomas Ivarsson

Deploying a Report

I'm having a little bit of trouble deploying the report project I have set up. In fact, I'm not even sure that deploying the project is what I want to do. All I want is to have something so I can view the report I've created in HTML or PDF form, something that was advertised when I downloaded the reporting services. Any help with what I would need with this would be appreciated.

Deploying your reports is what you need to do, but first you need to ensure that you have an instance of Report Server to deploy to - do you have that? Once you do, you just run the report, then you can specify whether you want to export it to PDF, Excel, etc.

|||I don't think I do have that. Or, if I do, I have no idea what it is. How would I get an instance of Report Server that I can deploy to?|||

So, it would seem that you have started up a new BI project, created some reports, and now need to make them visible to everyone? In that case, you need to find out from your DBA or sys admin where reporting services is installed (usually it resides on the same server as SQLServer), if you don't have one then you can install it from your SQLServer cd. Once done, you upload your datasource to it, and deploy your reports, set any rights you want on those reports (i.e. set the security on them), then to access your reports you would use a url similar to this: http://<your report server>/Reports/<any subfolder you created>/<your report name.htm>

Of course this is a very quick summary, you will find much more detail in BoL (Books On Line) and in the MSDN help (msdn.microsoft.com)

Hope that helps.

|||Yes, that definetly helps, thank you very much!