How to use reporting services with data mining ?

Hi ,

How can I use reporting services to get reports out of analysis Services Database ?

I found following on one site, but I tried to look for Analysis services database on the server I am deploying the model , but I am not able to find it.

'To use Reporting Services with data mining, you simply create a Reporting Services project with the BI Dev Studio and specify an Analysis Services database as your data source. Depending on the contents of the database, you will be presented with either an OLAP or Data Mining query builder as in Figure 3.23. You can always switch between the two modes by clicking the Switch '

thanks,

Vikas

Hi

Please try the following:

1. In your report project, right click the Shared Data Sources and select "Add New Shared Data Source"

2. In the Type box, select "Microsoft SQL Server Analysis Services"

3. Click on the "Edit" button. In the connection dialog, specify the Analysis Server name (Optionally instance name) in the Server name text box.

4. Drop the database name combo box and select the database name where your Data Mining models have been deployed.

5. Click OK to create a shared data source

When creating a new report, select this data source and select the "Query Builder". You should see a DMX query designer where you'll be able to create a dataset for your report.

Hope this helps. Please reply if you have any additional questions

Thanks

Shuvro

|||

Hi Shuvro,

I did everything you specified. But when I go to query builder window I do not see any mining model there. My mining project is fine. It shows me all models , lift charts etc in Analysis Services , which indicates the the SSAS Database I am using has all models etc. Why nothing is being shown whne I open the DB is RS ?

Thanks,

Vikas

|||

I think the UI is a little confusing. You'll see a empty Mining Model window with a button "Select Model...". If you click the button and navigate to the DB->Mining Structure->Mining Model and hit OK, the query window should get populated with the model and the columns

If this does not work, can you please send me a screen shot of your query window to (shuvrom at microsoft.com). at=@.

Thanks

|||Hi Shuvro,

Your answer is correct. However, that way I'm still unable to get the chart of decision tree using the Reporting Service (and Report Builder). How can I display the chart of decision tree, chart of time-series and clusters in the web? Your answer can only be used to display numbers that are the result of prediction-query or simple-query; not chart or picture in any way.

Thank you,

Bernaridho|||Currently there isn't any built-in way to display the graphical results of the DM viewers in a report. A sample that has thin client versions of the decision tree, classification and discrimination charts is provided if you install all of the samples included with the SQL Server product. You can also see these samples in action at www.sqlserverdatamining.com in the Live Samples section.|||Hi Jamie,

I've tried searching what you mean, but I have not found it.
Do you mean the thin client viewer? If that's what you mean, then I have problem downloading it yet I can try again later.

However, if you also mean one-or-more post(s) in sqlserverdatamining.com, could you please give the URL (or specific date) of that post(s)?

Thank you,

Bernaridho|||

The smples are included witht he product, but they need to be explicitly installed. To install, you need to click the advanced button on the page where you select components and drill down into the documentation and samples node.

The like I was referring to was http://www.sqlserverdatamining.com/DMCommunity/LiveSamples/52.aspx, where it shows the viewers in action.