I am working in Time series model tuning. I got negative values in
my predicted column. When i try to increase my MINIMUM_LEAF_CASES
parameter., the negative value is gone..
Is it correct?

Hai,
    I am getting negative values for the predicted column Detahs.
Logically deaths won't be in negative. But my algorithm don't know that.
Is it ok , if an algorithm predicts a negative value or we have to tune

i have two questions.
1. what does it mean a negative score (MSOLAP_NODE_SCORE) ??
2. what does it mean the attribute "exist" which is added to each item.. (item1 = exist, item2 = exist -> item3 = exist)
thanks a lot..

   I am working in timeseries model of sqlserver2005.
I am analyzing the Standard deviation factor of the prediction.
Since i got deviation in the predicted value, i tried to change my
algorithm parameters. eventhen my standard deviation doesn't change. I

Hai,
    I am working in timeseries algorithm.In my predicted data,I am not
getting predicted data for some of the key from the second mentioned
year(which is the timekey).

    I am using BI studio to develop my models. I workied in Time series
model. I changed the PERIODICTY_HINT Algorithm parameter. Now i want to
run the query to predict the standard deviation of the model.
whether is it necessary to deploy the whole project.

First let me say that I am not an SQL expert but can usually navigate some
pretty complex queries if I fight it long enough.
However, this one has me baffled. I am sure I am overlooking somehting
simple but not sure what that is. It only involves a single table.

I just want to make sure that approach/formula mentioned in the following link:
http://www.cmh.edu/stats/definitions/entropy.htm
could be used to calculate the entropy for decision tree split.
Please advise.

In the book Data Mining with SQL Server 2005, it mentions that the decision
tree splits the very first time and recursively based on the column with  
lowest entropy. I don't have the book handy so I can't mention the page. This
explanation is in the decision tree algorithm ...

how can i filter rules in a dmx query ?
NODE_CAPTION LIKE '%something%' doesn't seem to be recogenized by ssas..
help plzz

I am rying to learn datamining with ss05. And have this problem.
I have tried to build a clustering datamodel with a case based on a
organisation units and a nested table with activity data:
unit      activity       Measure(Fact)

I am trying to simulate mining model creation in SQL
Server 2005, in .NET.
When I tried to reference Microsoft.AnalysisServices.dll and
Microsoft.DataWarehouse.Interfaces.dll

I have been reading chapter on decision tree algorithm in sql server 2005
data mining book.
Even though it discusses the algorithm parameters very well, is there any
other source where

Key    F1    F2
1    100    20
2    99    20.5
3    98    21

I am just wondering how would I be able to integrate the data mining results with ASP.NET page. I followed the book, Data Mining with SQL Server 2005, chapter15, which gives an example how to implement a web cross-selling application. I have set up the role & permission in the ...