DM Windows Forms Controls in November Feature Pack for SS2005

Hello,

There is a download in the Feature Pack For Microsoft SQL Server 2005 - November 2005 for the Microsoft SQL Server 2005 Datamining Viewer Controls. Unfortunately I cannot find a shred of documentation for said controls. It would be nice to know what their names are, where they are installed, how you add them to your toolbox. Sample apps would be of great benefit as well (but I don't want to ask for too much).

Here is the description for the controls which I find somewhat confusing. Are they Web Controls or Windows Forms Controls?

The Data Mining Web Controls Library is a set of Microsoft Windows Forms controls that enable software developers to display data mining models created using Microsoft SQL Server 2005 Analysis Services in their client-side applications.

Wendell G.

I agree that documentation would be useful. In the meantime, this sample that demonstrates how to embed the viewer controls (which *are* Winform controls and not web controls, as the description mistakenly indicates) might help:

http://www.sqlserverdatamining.com/DMCommunity/Downloads/Links_LinkRedirector.aspx?id=1362

|||

Wow Raman, this is incredible! Thank you so much.

It appears these controls are the controls that the Business Intelligence Developer's Studio is built with. Does anyone know if these controls are redistributable? I am especially interested in the Microsoft.AnalysisServices.Controls, Microsoft.AnalysisServices.Graphing, and Microsoft.AnalysisServices.Viewers.

Do the controls require Analysis Services to be installed on the deployed workstation?

If Microsoft does not have these documented, is anyone writing a developer's book that explains how to use them?

Thanks again!

Wendell G

|||

Yup, these are the viewer controls hosted in BI Dev Studio and SQL Mgmt Studio and they *are* redistributable. The controls don't require an AS install on the workstation - they only require a subset of client components (just the AS 9.0 OLE DB driver, I believe - the install should pop up the appropriate prerequisites if they are missing).

We are hoping to provide documentation in a web refresh but I don't have a timeframe yet.

DM Graphs

I'm having the same issue. It's different depending on the algorithm. For example, in Mining Model Viewer, if I have a tree displayed and I right click on the tree, I get the options to "Copy Graph View," and "Copy Entire Graph." Those options will allow me to paste the tree graph into a Word doc. But if I'm in Cluster Analysis, I only get "Copy" when I right click on the chart. If I select it, and try to paste it into a Word doc, I get a table instead. I just assumed that the software wasn't finished yet and you couldn't copy those charts. But maybe it's a bug? I'm using SQL server standard edition on my desktop, single CPU.

That's the design of the copy functionality.

The graphical views copy as bitmaps and the tabular views copy as tables. There's a fine distinction between what's "graphical" and what's a "table" - essentially anything that looks "table-like" is a table, otherwise it's graphical.

The intention is that the graphics can easily be created from the table data. For example, if you download the Office 2007 beta and paste in what you copy from the Cluster Characteristics view, you can use the databars feature in Excel 2007 to easily create a facsimile of the Cluster Characteristics view.

For some views, notably the Cluster Overview view, the format of the table isn't very useful. This is fixed in SP2, which will release later this year.

|||Can we use the tabular data, say from Cluster, in Excel 2003 to recreate the "graphic" from Cluster analysis?