Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » DMX   (RSS)
Thursday, September 24, 2009 3:58 PM

The amazing flexibility of DMX Table Valued Parameters

When most people think of “Table Valued Parameters” they think of “ possibly the most anticipated T-SQL feature of SQL Server 2008 .”  However, little may you know, that the Data Mining team added table valued parameters and table valued functions
Posted by JamieMac | 0 Comments
Filed under: ,
Friday, December 12, 2008 1:42 PM

Querying the Dependency Net

OK, ok, so just yesterday I posted that it was easy to determine what queries were being used by the browsers to get the data underlying the view.  Of course it’s easy to get them, but without a teensy weensy bit of documentation, it’s not necessarily
Posted by JamieMac | 1 Comments
Filed under: ,
Tuesday, October 07, 2008 11:35 PM

Getting Data Mining results into SQL Tables

I've been seeing lots of questions about how to get data mining results into SQL tables. Most times the answers are "use the prediction query builder save button" or "build an SSIS package." Both of these have issues among them being that the former is
Posted by JamieMac | 1 Comments
Filed under: ,
Monday, March 10, 2008 1:49 AM

Unwinding MDX Flattening Semantics with DMX

When issuing an MDX statement in code, you have the option of requesting either a multidimensional set or a relational rowset as the result set. If you are familiar with MDX and multidimensional concepts, the multidimensional result is the obvious choice.
Posted by JamieMac | 3 Comments
Filed under: ,
Sunday, February 03, 2008 8:09 PM

DMX Queries - the DataSource hole

So many people have told me how much they like DMX - the fact that they can use a query language to create, train, and query mining models is simply unprecedented in the data mining world. And they love it. Until..... Until, that is, they decide to go
Posted by JamieMac | 2 Comments
Filed under: , ,
Sunday, January 13, 2008 9:36 PM

To (a) or not to (a), that is the question?

While looking for content for the next edition of my book (newsflash! I'm currently working on the next edition of my book!) I went hunting around for that trick using decision trees to predict the states of a single column independently rather than all
Posted by JamieMac | 1 Comments
Filed under: ,
Wednesday, April 25, 2007 9:11 AM

New DMX Syntax option in SQL Server SP2

Quite a while back I promised to tell everyone about the subtle new feature in DMX in SQL Server 2005 SP2. Well, that day has finally arrived, true believers – your patience has paid off! J One of the nice improvements we made to SQL Server 2005 DMX was
Posted by JamieMac | 0 Comments
Filed under:
Wednesday, January 10, 2007 12:00 AM

Predicting the non-majority state

The Predict() function in DMX always returns the highest probability non-missing (by default) state for the requested attribute. That is, if there are two states, the state with a probability higher than 50% will be returned. However in many cases you
Posted by JamieMac | 0 Comments
Filed under:
Tuesday, December 05, 2006 2:53 AM

Predicting based on rules alone and getting everything you always wanted

In this post I explained how to couch an associative prediction that omitted predictions that were based solely on marginal statistics. The one catch was that if you asked for 5 items, you might not get 5, you could get 4 or 3 or even down to 0, since
Posted by JamieMac | 1 Comments
Filed under: ,
Saturday, June 10, 2006 11:11 AM

Executing multiple DMX statements from SSMS

Many people have asked how to execute multiple DMX statements in SSMS, and my answer has always been "Analysis Services doesn't support IMultipleResults, so you can't execute multiple statements in a single document in SQL Management Studio." Well it
Posted by JamieMac | 0 Comments
Filed under:
Wednesday, April 19, 2006 1:18 PM

Predict based on rules alone

I've been asked this question a few times and never thought of an answer until I was asked again today on the data mining newsgroups. We'll be posting a tip or trick on sqlserverdatamining.com on this, but since it's fresh in my mind I'll let everyone
Posted by JamieMac | 1 Comments
Filed under: ,
Thursday, March 30, 2006 11:51 AM

Automatic Generation of CREATE MINING MODEL statements

I noticed through answering newsgroup and forum posts that we always want to know model definitions when discussing a problem. Luckily we have this great language called DMX that makes it very easy and simple to describe a model. Unluckily, our tools
Posted by JamieMac | 0 Comments
Filed under: ,
Tuesday, November 15, 2005 12:07 PM

Code from book and new XMLA template at SSDM

I just added a couple of new downloads on SQLServerDataMining.com The first is the sample from chapter 16 (Forecasting in Excel) of my book, Data Mining with SQL Server 2005 which was misposted on the publisher's site (it will be updated there as well,
Posted by JamieMac | 0 Comments
Filed under: , ,
Monday, March 28, 2005 6:06 PM

Time Series Prediction

Last week I was playing around with the Time Series algorithm - ok I was showing a customer - and I wanted to show the prediction language used to display the charts. So I used the tools and showed them the basic prediction query for forecasting, but
Posted by JamieMac | 0 Comments
Filed under: ,
 
Page view tracker