Data Mining not dead, but possibly forgotten

re: Data Mining not dead, but possibly forgotten

Josh Reuben — Tue, 16 Oct 2012 15:09:57 GMT

Not only is DMX dead (no changes since SQL 2005), but it looks like MDX is being abandoned too - the core devs have left MS and the focus has shifted to DAX - no new MDX features in SQL 2012.

re: Data Mining not dead, but possibly forgotten

Sean — Fri, 18 Nov 2011 14:06:04 GMT

I recall there being a registry hack that let me use the addin in excel 2010. Someone from MS advised me to go into the registry where the excel add ins are registred and set the key to enabled for the data mining addin. This worked but I had to do it every time I wanted to use the addin.

re: Data Mining not dead, but possibly forgotten

Andrew.Fryer — Mon, 19 Sep 2011 06:44:52 GMT

Pieter

Not at all sure what the problem is but it will work (as you can see from my screenshot), and we do support it. However I am not a support guy so you'll need either check technet forums or rais a call with us to resolve your issue.

Andrew

re: Data Mining not dead, but possibly forgotten

Pieter Linden — Fri, 16 Sep 2011 21:42:41 GMT

Hopefully I'm not hijacking someone's thread... I tried getting the existing Data Mining add-ins to work in Excel 2010 (worked fine in 2007), and it causes Excel to crash every time. I uninstalled 2010 and went back to 2007, and still the add-ins crash. Do I need to clean the registry or something... ??

re: Data Mining not dead, but possibly forgotten

Andrew.Fryer — Thu, 11 Aug 2011 06:42:57 GMT

Michael

I guess you would log this under Denali. I completely agree that the lack of and x64 version needs to be addressed.

Although PowerPivot and Data Mining sit side by side in Excel they don't really work together.

My other wish is for a decoupled data mining tool that doesn't sit in BI dev studio, much as we have with Report Builder 3.

However your voice carries more weigth than mine as you are a customer so Connect away please and get your colleagues to vote as well

re: Data Mining not dead, but possibly forgotten

Michael J. Swart — Mon, 08 Aug 2011 15:44:30 GMT

I would love to be able to use this feature.

I've got no luck with *64* bit Excel 2010. Is there a connect item for this? The lack of support me that Microsoft might be forgetting about this feature too.

The other options open to me are learning DMX (Is it as hard as MDX? Because that's daunting) or creating a model in BIDS. How hard is that to learn do you think?

re: Data Mining not dead, but possibly forgotten

Andrew.Fryer — Mon, 08 Aug 2011 06:33:45 GMT

Ron

That screenshot in the post above is Data mning and PowerPivot in Excel 2010, albeit 32bit Excel, so not sure what porblems you are having. However data mining built in to PowerPivot or BISM would be nice so post your thoughts on Connect.

Andrew

re: Data Mining not dead, but possibly forgotten

NorSivad (Ron Davis in a less generic form) — Sun, 07 Aug 2011 19:33:37 GMT

The data mining add ins for office do not function last time I checked in Office 2010. Hoping something comes out for PowerPivot