Jamie's Junk

Whatever comes to mind "The official blog of the SQL Server Analysis Services Data Mining Architect" (tm)

Browse by Tags

Tagged Content List
  • Blog Post: 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 to DMX in SQL Server 2005 .  Not only has this...
  • Blog Post: 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 easy to understand what the parameters mean...
  • Blog Post: 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 really only suited to single-use, small jobs, and...
  • Blog Post: 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. However, if your application is more suited to...
  • Blog Post: 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 whole hog on DMX and implement their entire...
  • Blog Post: 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 together. Turns out - I never wrote it! So, in...
  • Blog Post: 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 the ability to predict the probability of a...
  • Blog Post: 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 want a response to be a target state even though...
  • Blog Post: 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 all predictions without a corresponding prediction...
  • Blog Post: 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 turns out I was wrong, and I was wrong - in a sense...
  • Blog Post: 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 have it now. The problem that some people are...
  • Blog Post: 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 that we use to create models use an XML DDL that is...
  • Blog Post: 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, but it's at SSDM for those of you who want it...
  • Blog Post: 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 I wanted to go further and show them cool stats like...
Page 1 of 1 (14 items)