Error when using Analyze Key Influencers

[Database Administrator]

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
http://www.microsoft.com/sql/technol...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
dkhl@telia.com

[Database Administrator]

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

"Hans Larsson" wrote in message
news:ebQvv9Q4IHA.3624@TK2MSFTNGP05.phx.gbl...
> 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
> http://www.microsoft.com/sql/technol...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
> dkhl@telia.com
>