data mining viewer controls.....

i'd like to add the data mining viewer controls into visual c# 's toolkit....is it possible...

is there a way how i could create forms and import the minned pattern into these forms using the data mining viewer controls?

infact i am trying to make use of the data mining viewer controls to migrate the minned results from BIDS to a form or to a web page......so what would the first step be? i have already installed the data mining viewer controls...but then i don't see any of these web controls in my toolkit...

what is my next step? is it adding these installed contrls onto the visual c# web developer toolbar?(toolkit) please correct me if i am wrong......and what would b my next step in achieving this?

Data Mining Model Viewer of Decision Tree out of memory error

We've successfully processed a large decision tree model in SQL Server 2005. When I try to view the tree in the mining model viewer, I get the following error:

TITLE: Microsoft Visual Studio

The tree graph cannot be created because of the following error:

'Exception of type 'System.OutOfMemoryException' was thrown.'.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.AnalysisServices.Viewers.SR&EvtID=ErrorCreateGraphFailed&LinkId=20476

The link provides no other documentaiton on the error.

We're using 64-bit SQL on a Dell Workstation running XP-64 with 16GB of memory. From my view of things we aren't close to running out of memory. Since the model processed and the error occurs when viewing the model, is this a problem with Visual Studio and nont necessarily Anlaysis Services?

Thanks in advance.

Nick

Hello, Nick
As you said, it seems a viewer problem and not a server problem.
There is a simple way to find out: start the Profiler tool (All Programs\SQL Server 2005\Performance Tools\SQL Server Profiler) and connect to the Analysis Services instance.

Then, try to browse the model. If the error is coming from the server, you should see it in the trace.

If possible, please save the trace file and post it (or send it to me directly,
bogdanc AT microsoft DOT com), so that we can trace the problem

thanks|||

Bogdan,

Thanks for looking into this. The model errored I don't see any errors in the trace but I'm not sure. I'm very familiar profiler in term of SQL Server but Analysis Services. I'll send the trace directly to your email.

Nick

|||It looks like the tree has a really large number of nodes (around 34 000) and the viewer has troubles handling that many nodes and runs out of memory. We will definitely try to address this issue in future versions.
Meanwhile, here are a few suggestions:
- Increase the COMPLEXITY_PENALTY or the MINIMUM_SUPPORT parameters of the mining model. These would effectively reduce the complexity of the tree, bringing it to a more manageable size.
- Use the "Generic Content Tree Viewer" sample. It can be downloaded from here http://www.sqlserverdatamining.com/DMCommunity/_Downloads/1348.aspx
It allows interactive navigation of the model content and it provides access to all the information inside the tree viewer
- Use the Data Mining add-in for Visio -- it allows rendering of only the top levels of a tree

Data Mining Html Tree Viewer Authentication

I am going through the data mining web control viewer tutorial and its going great. I have been able to build and setup the viewer. The problem I am having is when I publish the site out to my web server, it gives me the following error:

Code Snippet

Error: Either the user, <domain>\<computerName>$, does not have access to the prospectDataMining database, or the database does not exist.

When I debug this on my local machine via Visual Studio 2005, it works GREAT! It is just when I publish the site to the web server.

I have a dedicated SSAS server along w/ a dedicated web server. To test, I published the site to the SSAS server to see if it was a connection issue. I received the same error w/ a different <domain>\<computerName>$.

I looked at trying to put in the optional connection info for the dataMining html tree viewer properties... but apparently dont know how to do that properly. I also checked the IIS directory security and enabled Integrated security.

What am i doing wrong? ANY help is much appreciated.

Thanks,

Cameron

Could you try the following:

- edit your web application's web.config file (add one to the project if not present)

- <configuration

<system.web>

<identity impersonate="true">

Setting up integrated security on the IIS virtual directory is necessary, but not enough -- .Net impersonates (or not) depending on the web.config file

Alternately, you could skip the web.config file changes and add Analysis Services permissions for thge localhost\ASPNET (only works if AS is on the same machine as IIS)