| |
| ||||||
A caution on using Dimensional DSVs in Data Mining - part 2This is a discussion on A caution on using Dimensional DSVs in Data Mining - part 2 within the BI Monkey forums, part of the CORTEX Blogs category; As a followup to this post I have found that not only does using a table external to the one being mined to provide a grouping fail to actually group ... |
 |
| | LinkBack | Thread Tools | Search this Thread | Display Modes |
23rd June 2009, 09:34 PM
| #1 |
| Guru Join Date: Jun 2009
Posts: 122
 |  A caution on using Dimensional DSVs in Data Mining - part 2 As a followup to this post I have found that not only does using a table external to the one being mined to provide a grouping fail to actually group within the model, it also confuses the Mining Legend in the Mining Model Viewer. What I was seeing in the Mining Legend for a node in a Decision Tree was like this: Total Cases: 100 Category A: 10 Cases Category B: 25 Cases Category C: 0 Cases Category D: 9 Cases … so the Total cases and the cases displayed didn’t tie up. By digging further using the Microsoft Mining Content Viewer and looking at the NODE_DISTRIBUTION I saw that there were multiple rows for the categories, and the Mining Legend was just picking one of those values. So if you find youself looking at a node and wondering why the numbers don’t add up - it’s because your grouping hasn’t been used by the model. More... |
|      |
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Dimensional Operational Reporting Data Stores | Doug Heywood | Data Warehousing Tips and Techniques | 1 | 18th October 2011 06:36 PM |
| Data Mining | Steve Bennett | Analytics | 10 | 23rd October 2009 09:23 AM |
| The Flaws of the Classic Data Warehouse Architecture, Part 1 | glove | Data Warehousing | 2 | 12th May 2009 12:45 PM |
| SAS® Enterprise Miner™ unrivaled in data mining | Latest News Headlines | SAS Forum | 0 | 28th April 2009 10:32 AM |
| ACS - BUSINESS INTELLIGENCE - The Dimensional Insight BI “Diver Solution” | RolandBeck | Local Happenings | 0 | 17th November 2007 08:40 AM |
| | |
| | |
Linear Mode
