none
DMpredict function is not installed?

    Question

  • I've recently installed the SqlServer 2012 Data Mining Add-ins for Excel 2010 on Excel 2013. I've built several models, and now I'm ready to create an application using the dmpredict function. Unfortunately, there doesn't seem to be a dmpredict function. When I try to enter the function (i.e. =dmpredict(with all the parameters) ) I get a #Name? error. Can anyone help me figure out how to get the functions installed?
    Monday, June 30, 2014 9:04 PM

All replies

  • Hi Bc,

    Since you are try to install the Data Mining Add-in for Excel 2013 other than Excel 2010, you need to install the SQL Server 2012 SP1 Data Mining Add-ins for Microsoft Office version from:
    http://www.microsoft.com/en-us/download/details.aspx?id=35578

    Regards,
    Mike Yin

    If you have any feedback on our support, please click here


    Mike Yin
    TechNet Community Support


    Wednesday, July 02, 2014 3:59 PM
  • Mike,

    Thanks for the help.  I installed the later version, but I still don't have the dmpredict function.  Do I need to uninstall the earlier version first?

    Wednesday, July 02, 2014 5:50 PM
  • Thanks for posting -- I tried today, and it looks like an omission.  Using Visual Studio, I tracked down the installation to the DLL which has the intended 3 Excel functions:

    %installdirectory%\Microsoft SQL Server 2012 DM Add-Ins

    Microsoft.SqlServer.DataMining.Office.Excel.DMClient.dll

    You can see this information in Object Browser:

    Public Function DMPREDICT

    (Connection As String, Model As String, PredictionResult As String, value1 As Object, name1 As Object, value2 As Object, name2 As Object, value3 As Object, name3 As Object, value4 As Object, name4 As Object, value5 As Object, name5 As Object, value6 As Object, name6 As Object, value7 As Object, name7 As Object, value8 As Object, name8 As Object, value9 As Object, name9 As Object, value10 As Object, name10 As Object, value11 As Object, name11 As Object, value12 As Object, name12 As Object, value13 As Object, name13 As Object, value14 As Object, name14 As Object, value15 As Object, name15 As Object, value16 As Object, name16 As Object, value17 As Object, name17 As Object, value18 As Object, name18 As Object, value19 As Object, name19 As Object, value20 As Object, name20 As Object, value21 As Object, name21 As Object, value22 As Object, name22 As Object, value23 As Object, name23 As Object, value24 As Object, name24 As Object, value25 As Object, name25 As Object, value26 As Object, name26 As Object, value27 As Object, name27 As Object, value28 As Object, name28 As Object, value29 As Object, name29 As Object, value30 As Object, name30 As Object, value31 As Object, name31 As Object, value32 As Object, name32 As Object) As Object

         Member of

    Microsoft.SqlServer.DataMining.Office.Excel.ClientConnect

    Though, the installation seems to be either incorrect or incomplete.  I have sent a query to someone I know at Microsoft to see if we can have an answer on this topic.

    For reference, here are the signatures for the other two functions:

    Public Function DMCONTENTQUERY

    (Connection As String, Model As String, PredictionResult As String, WhereClause As String) As Object

         Member of

    Microsoft.SqlServer.DataMining.Office.Excel.ClientConnect

    Public Function DMPREDICTTABLEROW

    (Connection As String, Model As String, PredictionResult As String, TableRowRange As Range, CommaSeparatedColumnNames As String) As Object

         Member of

    Microsoft.SqlServer.DataMining.Office.Excel.ClientConnect


    Mark Tabladillo PhD (MVP, SAS Expert; MCITP, MCAD .NET) http://www.marktab.net

    Wednesday, July 23, 2014 6:09 PM
  • By the way -- I am running x64 Office 2013 -- I'm wondering if the issue is x86 (32 bit) versus x64 (64 bit). --- though the Add-in is supposed to work for both situations.

    Mark Tabladillo PhD (MVP, SAS Expert; MCITP, MCAD .NET) http://www.marktab.net


    Wednesday, July 23, 2014 6:16 PM
  • I've recently installed the SqlServer 2012 Data Mining Add-ins for Excel 2010 on Excel 2013. I've built several models, and now I'm ready to create an application using the dmpredict function. Unfortunately, there doesn't seem to be a dmpredict function. When I try to enter the function (i.e. =dmpredict(with all the parameters) ) I get a #Name? error. Can anyone help me figure out how to get the functions installed?

    This issue is a bug:   Please vote for the Connect item https://connect.microsoft.com/SQLServer/feedback/details/928142/excel-data-mining-add-ins-have-disabled-excel-cell-functions-dmpredict-dmpredicttablerow-dmcontentquery

    Mark Tabladillo PhD (MVP, SAS Expert; MCITP, MCAD .NET) http://www.marktab.net

    Thursday, July 24, 2014 6:18 PM