| |
| ||||||
A caution on using Dimensional DSVs in Data MiningThis is a discussion on A caution on using Dimensional DSVs in Data Mining within the BI Monkey forums, part of the CORTEX Blogs category; If you are using a dimensional-style DSV in a Data Mining project, such as below: Fig 1: A Dimensional DSV Be aware that if you include a column from a ... |
 |
| | 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 If you are using a dimensional-style DSV in a Data Mining project, such as below:  Fig 1: A Dimensional DSVBe aware that if you include a column from a Dimension table in your Mining Structure, the model will actually identify each key entry on the source table as a distinct value, rather than each distinct value in the Dimension table. I found this out because I added a grouping category to one of my dimensional tables - a simple high - medium - low group - and there were multiple values in the attribute states for each grouping, as below:  Fig 2: Mining LegendTo work around this you will need to add a Named Calculation to get the group on the main table, or convert the main table to a Named Query. 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 |
| Mining | admin | Local Industry Channels | 3 | 12th November 2010 01:25 PM |
| Data Mining | Steve Bennett | Analytics | 10 | 23rd October 2009 09:23 AM |
| A caution on using Dimensional DSVs in Data Mining - part 2 | James Beresford | BI Monkey | 0 | 23rd June 2009 09:34 PM |
| SAS® Enterprise Miner™ unrivaled in data mining | Latest News Headlines | SAS Forum | 0 | 28th April 2009 10:32 AM |
| | |
| | |
Linear Mode
