Error when using Analyze Key Influencers

Hans Larsson

2008-07-10 13:14:26 UTC

Found the cause:
I had 3 different versions of SQL:
1) SQL Express
2) SQL Compact 3.5
3) SQL Standard Ed
The Hotfix f SQL Server 2005 SP2 was not applied to 3) because I had
uninstalled/reinstalled 3)
When I tried to install/reinstall the Hotfix it was confused....and it could
not be done!
Resolution:
I uninstalled all SQL Servers on my desktop and then I installed SQL 2005
Dev Editiom SP2
Then I installed the DMAddIns for Excel 2007 and it works!

Hans Larsson

Post by Hans Larsson
Hi,
I am testing and learning Data mining from Excel 2007
I have installed SQLServer2005_DMAddin.msi
I think everything is installed and set up ok...?
When I try the sample(just like on the MS Video on the help on the Web) on
Analyze Key Influencers
I get a Error(Data mining): The 'MINIMUM_DEPENDENCY_PROHABILITY' data
mining parameter is not valid for the 'Table2_907314_219314'.
Just like he does on the video
www.microsoft.com/sql/technologies/dm/addins.mspx
Just like on the video I choose the 'Purchased Bike' as the column to
Analyze then just click on Run.
I does not matter what I try with the Analyze Key Influencers I always get
the same Error.
-Detect Categories-
-Fill From Example-
-Forecast-
samples works OK!
Can anybody help me what the error means?
Thanks!
Hans Larsson
--
______________________________
Datakonsult Hans Larsson
www.dkhl.com