all groups > sql server data mining > may 2007
How to Disable a GROUP BY - HAVING
Posted by LUIS at 5/29/2007 4:44:14 PM
I have four tables,
1. First has Items,
2. Second has Features,
3. Third defines the ItemsFeatures
4. And temporary that sets which Items have to SELECT according Features
For this statment we do not need table(2),
IF (SELECT COUNT(*) FROM tblTemporary) = 0
SELECT A.ItemID, B.ItemDescr... more >>
create dimensions programmatically
Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 5/29/2007 2:40:20 AM
I am trying to create dimensions to an analysis services programmatically
This is the code I am using
DimensionAttribute attr;
attr = dim.Attributes.Add("KEYCOLUMN");
attr.Usage = AttributeUsage.Key;
attr.Type = AttributeType.Regular;
attr.OrderBy = OrderBy.Ke... more >>
Data validation question
Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 5/29/2007 1:40:13 AM
Hi,
I'm a bit confused by the data validation sample. In the code the predicted values are compared to the submitted values. The PredictProbability function is called for Gender, Occupation, and HOH since they're discrete, and PredictVariance is called for Age and Education. It looks like a measu... more >>
does vb.net works in windows vista?
Posted by abdullah at 5/29/2007 1:25:00 AM
hi i just wanna ask does vb.net2003 works with windows vista or not
thanx
... more >>
Microsoft time series Algorithm for Budgeting
Posted by Marc at 5/28/2007 2:27:00 AM
Dear all
I'm thinking about useing the Microsoft time series Algorithm on historic
sales data for budgeting retail sales.
Will this work well?
I want to make some adjustments e.g. increase / decrease sales for distinct
product categories, stores and month. For that I need to store the r... more >>
ANALYSIS SERVICES SERVER REMOTE CONNECTION
Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 5/26/2007 4:00:15 PM
I am trying to connect to an analysis services server remotely
I am using the following code:
Microsoft.AnalysisServices.Server srv = new Microsoft.AnalysisServices.Server();
srv.Connect("192.168.0.126");
I tried using the remote machine's name srv.Connect("remotemachinename") but still doesn't ... more >>
MINING STRUCTURE USING CUBE
Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 5/23/2007 6:20:14 PM
I want to create a mining structure using a cube programmatically
All the examples I found use as a source a datasourceview to build the mining structure.
But we built a cube using a datasourceview and the next step is to build the mining structure using the cube.
Can anyone help me ?
George
ge... more >>
Data Mining / BI products
Posted by dcuff via SQLMonster.com at 5/22/2007 9:26:24 PM
Can anyone give any suggestions for great Data Mining and Business
Intelligence products on the market for SQL Server 2005? Are the built-in
products for this any good? I am just starting out looking into this. Thanks
for any help is appreciated.
--
Message posted via http://www.sqlmonster.c... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Multicollinearity
Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 5/22/2007 9:20:13 PM
What kinds of precautions are taken in Microsoft Logistics Regression algorithm in order to ensure that multicollinearity is not a problem in the model?
In other words, should we check our model against multicollinearity or is it handled by the algorithm?
Thanks in advance, Afsin... more >>
Adventure Works DW
Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 5/17/2007 12:00:00 AM
Hello,
I am trying to find out which version of Adventure Works DW database version are you using in an Over View Of DM web cast , since i can't seen some of the tables like new customers and target mail. Is there any othere version or you set and created some new tables only for this example.
... more >>
|