Datamining Viewer Client Problem

Hello!

I am running a SQL Server 2005. I created the mining models from the tutorials. I can connect with the DataminingViewerClient directly on the SQL Server(i.e. to localhost), but when i try to connect to the Server from my other computer it is not working i always get connection faild and i should check that the server is running. I can connect to the Server with other programms but the viewer is not working. Any ideas what that could be?

Can you connect to other servers from the machine where the DataminingViewerClient application works? If so, it may be that there are additional client components that need to be installed. Let us know and we can continue to diagnose.

Thanks

-Jamie

|||Ok i now tried to connect from Server A to Server B, not working either. It works on both when i run the viewer directly on the server and connect to localhost but not from Server A to B or vice versa or from any other computer. Could it be that some permissions are missing, because in the dataminingviewer client i dont have to specify a user/password for the server where the analysis-service runs. I dont think that components are missing because i can compile the source code without errors, but i'll be happy about any hint that might help.

Another thing i tried: When i create a datasource on Server A to connect to Server B(or from any other computer) it only works when I use the sa user(Windows Authentication doesnt work), otherwise i cant browse/select the databases.|||In general AS only uses Windows Authentication, unless you connect over http (requires configuration - see books online). Connecting over http allows you to specify a username and password. For the DM Viewer Client, you cna modify the code to use a http connection, or prompt for username and password. The source code is provided.|||

Hello again!

I found the error...the server was not in the domain, after we added it it worked.

DATAMINING tasks

what are the different data mining tasks...........

The most common basic data mining tasks (supported by SQL Server 2005) are classification, regression, clustering, forecasting, association analysis, correlation analysis.

All tasks act as blocks in solving a really large set of business problems.

A few starting points:

- http://www.microsoft.com/sql/technologies/dm/default.mspx -- The tutorial and the Webcast ("Introduction to Data Mining in SQL Server 2005") provide a good description of what data mining tasks are supported in SQL Server, plus details on the tools

- http://www.sqlserverdatamining.com -- lots of information, tutorials etc.

|||

A nice classification of data mining tasks is given by David Hand et.al in Principles of Data Mining (2001):

1. Exploratory data analysis (Visualization)

2. Descriptive modelling (Cluster analysis, relationships between variables...)

3. Predictive Modelling (Regression, Classification,...)

4. Pattern Discovery (Association Rules, outlier detection,...)

5. Retrieval by content (start from a given pattern and try to find similar patterns)

This provides a very general viewpoint on all different kinds of tasks.

DataMining problems

Hello Experts,

I’ve got a logical problem. I’m just a newbie in this theme.

I build a cube with Analysis Services. It works and I can brows the cube.

For Example this could be a possible result:

Color

RedBlueBlackYellow

Auto brand

Opel12

VW214

Mercedes1122

The count shows us how much cars were stolen.

Now I try to build a Data Mining structure that shows me the behavior between the auto brand and the color. (To build the report I used Excel 2007 and the Data Mining AddIn)

After build the Mining Structure the Colum name are 1, 2 or 4 (just the counts).

To search for a better solution I tried to build the report manual. (Now it looked like that)

Auto BrandCollorstolen

OpelRedno

OpelBlueyes

OpelBlackyes

OpelYellowno

VWRedyes

VWBlueyes

VWBlackno

VWYellowyes

MercedesRedyes

MercedesBlueyes

MercedesBlackyes

MercedesYellowyes

Now the Column names are correct and the Data Mining structure is more understandable.

But the second report you can’t build with a cube, because the Measures were just numeric.

My Questions:

- Where is my error?

- How do you build a Data Mining?

- Is there somewhere a tutorial could help me (I just founded tutorials that explains the different works of the different Data Mining Models)

- How would you build this problem in a Mining Structure?

Hope I don’t forget some information and hear you soon

Yours sincerely,

Alex

Please visit our portal site ssdm.com. You can find tutorials, tips and tricks as well as samples there.

As to your problem, it depends on what information you wish to analyze. For example, you can build a data mining model using some classification algorithms (such as decision trees and neural network). If you mark stolen as predictable, you can use your model to predict the probability that some specific type of car got stolen. You can also train a clustering model to assist in exploring your data.

Thanks,

DataMining on Chart

Hi!

Is it possible to do datamining on chart element ? I have a report that display sales per year (Y axis Sales, X axis = Year ). What i want is when i click on a values of my chart to launch the report per Month.
I've added on the chart values the action Jump To Report. When i click on my graph i can open the report per month . My problem is that the report display all month for all years and what i want is to display only month for the year click on the report per Year. For example if i click on the report per Year a values which is year is 2006 i want my report to open for all the month in the year 2006 but i don't know how to detect which values was click.

Is it possible to do something like that ?

Thanks and sorry about my bad English ^_^
Well i found how to do it. I added parameter to my report per month and when i click on my report per year i send a start and end date for the year click. It seems to work fine.

Datamining for ntext

Is there any way to datamine using ntext? I'm trying to run some BI on some email messages -- seeing if it can accurately classify email into the proper folder. Currently, I get complains that ntext isn't comparable.

Is this scenario supported?

You will need to use Integration Services to preprocess the messages into terms and phrases using the Term Extraction and Term Lookup transforms. From there, you can use the algorithms to perform classification. FYI, Logistic Regression tends to have good results for these types of problems.|||Thanks.

Say I have extracted terms from both subject and body. Thus, I have two sets of terms. Lets also say that I have a table with data conetaining all the header information.

How do I feed all three of these sets (subject terms, body terms, and header data) into a datamining transform?|||

It depends on what you really want to do. You can merge them using merge transforms in Integration Services to do term extraction. On the term lookup side, you can do the same. However, you may want to output the results of the different sets to different tables so you can seperate their inputs as input to a mining algorithm.

For example, the phrase "Data Mining" in the subject may have different predictive power than "Data Mining" in the body.

Note that Integration Services does not support nested tables. To implement such a process, your SSIS pipeline will have to put the data into tables that you mine using the Analysis Services project user interface.

Datamining concepts

What does cluster represent? Does anyone know any good resources for datamining

with ssas 2k5? I tried BOL but, I found out they don't seem to help that much Except to make you understand what each tab does.. any suggestions?

thanks,

Rok

Here baseline info about the Cluster Algorithm in SQL Server 2005:

(The Microsoft Clustering algorithm is a segmentation algorithm provided by Microsoft SQL Server 2005 Analysis Services (SSAS). The algorithm uses iterative techniques to group cases in a dataset into clusters that contain similar characteristics. These groupings are useful for exploring data, identifying anomalies in the data, and creating predictions.)

The first link below scroll to the end you will see all the SQL Server 2005 datamining Algorithms, the second is where you will find tutorials and the last link is the math used to create most prediction related calculations. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms175595.aspx

http://www.sqlserverdatamining.com/DMCommunity/

http://mathworld.wolfram.com/topics/ProbabilityandStatistics.html

Datamining a Olap Cube

I'm new to datamining and have gather some knowledge by following the tutorial that comes with sql server 2005.
I have following created a association mining model and tested it by using various DMX queries. I works quite satisfactory.

But I would like to use this mining model on a cube. Ie a calculated measure that would show top 1 recommendation for my customer portfolio.
My knowlede reaches to the extent that you need to feed data by using the OpenQuery or OpenRowset queries.
I would like to "stick" my model to the cube on some way and the extract values in the same manner as filtering criterias in stead of manually generating DMX queries.

I have googled a bit and searched MSDN without luck. Maybe I'm looking at this all wrong.

Is this possible?

Regards Bergur

Could this help?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1640504&SiteID=1

It presents an example of how to create a custom action containing a data mining prediction. Not really a calculated measure, but still a way to associate a prediction result with an cube cell.

Alternately, you could try this more complex approach:

- have your transaction data in the same cube

- build an OLAP mining model based on the cube

- use the MDXPredict MDX function to retrieve predictions from a mining model inside the calculated measure

Datamining a Olap Cube

I'm new to datamining and have gather some knowledge by following the tutorial that comes with sql server 2005.
I have following created a association mining model and tested it by using various DMX queries. I works quite satisfactory.

But I would like to use this mining model on a cube. Ie a calculated measure that would show top 1 recommendation for my customer portfolio.
My knowlede reaches to the extent that you need to feed data by using the OpenQuery or OpenRowset queries.
I would like to "stick" my model to the cube on some way and the extract values in the same manner as filtering criterias in stead of manually generating DMX queries.

I have googled a bit and searched MSDN without luck. Maybe I'm looking at this all wrong.

Is this possible?

Regards Bergur

Could this help?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1640504&SiteID=1

It presents an example of how to create a custom action containing a data mining prediction. Not really a calculated measure, but still a way to associate a prediction result with an cube cell.

Alternately, you could try this more complex approach:

- have your transaction data in the same cube

- build an OLAP mining model based on the cube

- use the MDXPredict MDX function to retrieve predictions from a mining model inside the calculated measure

dataMining

i create a model mining to know percent of product, which is like more by customer is have percent biger than other products that is don't like by customer.

i use DTS to get result to sql server.

select flattened

predict([modelName].[tablePredict],Include_statistic)

from

[modelName]

prediction join

.....

i have result with a table A in sql server:

productid $support ... $adjustedprobability

1 0.0 ...

1 0.0 ...

1 63.3 .....

how can i write in Dts so that table A not have record with value $support=0.0

- second: percent people like that product is knowned by $adjustedprobability or $support and value small or big

I've moved you thread to a forum where you are more likely to get an answer. You had submitted your question to the LINQ forum which isn't related to DTS.|||answered here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=829881&SiteID=1