Data Mining Web Controls Library

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

This sample works only with SQL Server 2005 and SQL Server 2008. It will not work with any version of SQL Server earlier than SQL Server 2005.
Data Mining Web Controls Library is a library intended to extend the data mining user experience in Microsoft SQL Server Analysis Services to the Web. This library provides a lightweight version of the data mining model viewers. Using Data Mining Web Controls, you can browse complex mining models from any computer that has Microsoft Internet Explorer installed.
The controls are server side. That is, the controls are located in the memory space of a Web server. The Web server can be, but does not have to be, the computer where Analysis Services is installed. However, Internet Information Services (IIS) and ASP.NET 2.0 (and later versions) must be installed and running on the computer where Data Mining Web Controls will be installed.
The documents and source code associated with each of these samples are located in the C:\Program Files\Microsoft SQL Server\100\Samples\Analysis Services\DataMining\Data Mining Web Controls folder.


Transact-SQL and C#


The Data Mining Web Controls sample uses the SQL Server Analysis Services features listed in the following table.

Application Area Features
DMClusterViewer Clustering Algorithm
DMDecisionTreeViewer Decision Trees Algorithm
DMNaiveBayesViewer Naïve Bayes Algorithm
Overall Analysis Services, OLE DB, Transact-SQL, AdventureWorks sample databases


Before you run this sample, make sure that the following software is installed:
  • Microsoft SQL Server, which includes the following components:
  • SQL Server Database Engine
  • Analysis Services
  • SQL Server Management Studio
  • Business Intelligence Development Studio
  • Two sample databases—Adventure Works DW (data warehouse) and AdventureWorks (OLTP)
  • Analysis Services Samples
  • Adventure Works DW Analysis Services project, deployed to an instance of Analysis Services
  • .NET Framework SDK 2.0 or Microsoft Visual Studio 2005. You can obtain .NET Framework SDK free of charge. For more information, see Installing the .NET Framework SDK in SQL Server Books Online. An updated version of AdventureWorks database is also available for download on the SQL Server Developer Center Web page.
An updated version of the SQL Server Database Engine samples is also available for download on the SQL Server Developer Center Web page.

SQL Server Business Intelligence Development Studio is not supported on computers that run the Itanium-based platform; the 64-bit development environment is supported on x64-based platforms. SQL Server samples can be modified and run on computers that run either x86 or x64-based platforms when databases used by the samples are deployed on an Itanium-based platform.

Building the Sample

Before you build the sample, make sure to install Analysis Services on the computer that is running the Web server. If you cannot install Analysis Services completely, at least install the client connectivity part—in particular MSOLAP, the OLE DB provider for Analysis Services—on the server. The Data Mining Web Controls need this provider to connect to the server that is running Analysis Services and the data mining models.
To build the sample, you will have to do the following tasks:
  • Install and deploy the Adventure Works DW sample Analysis Services project. This project contains the mining model which will be used in the project.
  • Build and install the Data Mining Web Controls. The following procedures show how to do each of these tasks for the installation.
To deploy the mining model
  1. In Windows Explorer, locate C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks Analysis Services Project, open the folder that corresponds to the edition of SQL Server that was installed, and then double-click the Adventure Works.sln file. The Adventure Works DW project opens in Business Intelligence Development Studio.
  2. Press F5 to build and deploy the project. Note: Building and deploying the AdventureWorksAS project deploys the mining model to the server.
To build and install the Data Mining Web Controls
  1. In Windows Explorer, locate C:\Program Files\Microsoft SQL Server\100\Samples\Analysis Services\DataMining\Data Mining Web Controls, and then double-click the WebControls.sln file.The WebControls solution opens in Visual Studio.
  2. On the Build menu, click Configuration Manager.
  3. In the Configuration Manager dialog box, select the Build check boxes for both the DMHTMLViewersSetup and WebControls projects (if not already selected).
  4. On the Build menu, click Rebuild Solution.
  5. In Windows Explorer, locate C:\Program Files\Microsoft SQL Server\100\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControlsSetup\Debug, and then double-click the setup.exe file.
  6. In the Microsoft SQL Server Data Mining HTML Controls Setup Wizard, click Next, and then Next again to start the installation of the controls.
  7. After the controls have been installed, click Next and then Finish to complete the wizard.After the wizard finishes, the following folders will have been added to the server:
  8. The C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers folder that contains the library, the source code for the controls, and this document.
  9. The C:\Inetpub\wwwroot\aspnetclient\microsoftanalysisservices_datamininghtmlviewers folder that contains client-side scripts and images used by the Data Mining Web Controls. This folder is also Web shared.

Adding the Controls to an Application

After building the sample, you can use the data mining controls. To use these controls, you must first create an ASP.NET Web application, add the controls that you want to the application, and then configure the controls that have been added.
To add the data mining controls to a Web application
  1. In Microsoft Visual Studio .NET, on the File menu, and click New Web Site.
  2. In the New Web Site dialog box, select ASP.NET Web site, select Microsoft Visual Basic or Microsoft C# as the language, and then click OK.
  3. If Toolbox is not currently visible, on the View menu, click Toolbox.
  4. In Toolbox, expand the category to which you want the data mining controls (for example, expand Standard), right-click within that category, and then click Choose Items.
  5. In the Choose Toolbox Items dialog box, locate and open the C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers\Microsoft.AnalysisServices.DataMiningHTMLViewers.dll file.The three data mining controls appear in the list of components and their check boxes have automatically been selected.
  6. Click OK.The three data mining controls should now appear in the selected category within Toolbox.
  7. To add a data mining control to the application, drag the control from Toolbox onto the Web form design page.After you add a data mining control on the Web form page, there are some control properties that you must set and some that are optional. The next section describes how to set these properties.

Setting Control Properties

A data mining Web control has two categories of properties:
  • The Data Mining Content category contains properties that define the model to be displayed. Among these properties, there are properties that must be set to use the control. The following table lists the properties shared by all the Web controls and indicates which of these properties must be set for all controls. * Property Type Default Requires changes ServerstringLocalhostYesDatabasestring<empty>YesModelstring<empty>YesConnectionSystem.Data.OleDb.OleDbConnection(none)No* In addition to these common controls, the DMDecisionTreeViewer control has additional Data Mining Content properties that must be set. For more information about these additional properties, see the section that describes how to set the properties for the DMDecisionTreeViewer control.
  • The Data Mining Layout category contains graphical properties for the controls. As the graphical representation for each data mining Web controls is different, the graphical properties associated with the controls vary correspondingly. You can use the default settings for these properties as is. To set the properties for a control, you use can use the Properties window in Visual Studio. If you cannot see the Properties window, right-click the control, and then click Properties. Also, to easily access the properties of the control, in Properties, select the Categorized view.

Also, you can set these values programmatically in the code shown on the Source tab.

{" Setting DMClusterView Control PropertiesYou can use the DMClusterViewer control to display the content of models created using the Microsoft Clustering algorithm. Not as rich as the cluster viewer found in Business Intelligence Development Studio, the cluster viewer for this control only supports cluster characteristics and cluster discrimination.The DMClusterViewer control has properties in the Data Mining Content category that must be set and optional properties in the Data Mining Layout category whose default settings can be used as is.Setting the Data Mining Content Properties for the DMClusterView ControlThe properties in the Data Mining Content category that must be set for the DMClusterView control are those properties shared by all the Web controls—Se

Last edited Jun 5, 2007 at 5:33 PM by bonniefe, version 6


thesuraj Jul 13, 2011 at 6:39 PM 
I cannot see folder " C:\Program Files\Microsoft SQL Server\100\Samples\Analysis Services\DataMining\Data Mining Web Controls" after installation.
I am using 32 bit msi file.