none
SQL Data Mining Addin with Excel macro (Shopping basket analysis) RRS feed

  • Question

  • HI,

     

    Is it possible to write a macro to run a shopping basket analysis in Excel 2010? Every time I try this the macro is empty.

    I have the SQL server DM add-in installed and if i run it manually it works great. What i want to do is create a macro that will run a predefined Shopping Basket analysis on the users data. This way it prevents them from having to configure it themselves. 

    Any help on this would be greatfully received.

    Simon

    Monday, January 10, 2011 1:16 PM

Answers

  • Microsoft SQL Server data mining add-ins don't provide macro support.

    One of Microsoft partners (Predixion Software) provides macro support for data mining tasks in Excel as well as public API that can be used within other systems.


    Tatyana Yakushev [PredixionSoftware.com]
    Tuesday, January 11, 2011 9:56 PM
    Answerer

All replies

  • Hi Simon,

    I have a similar issue. I want to run predefined analysis, could you share your code here? I want to give a try. Thank you!

    Tuesday, January 11, 2011 6:33 AM
  • Microsoft SQL Server data mining add-ins don't provide macro support.

    One of Microsoft partners (Predixion Software) provides macro support for data mining tasks in Excel as well as public API that can be used within other systems.


    Tatyana Yakushev [PredixionSoftware.com]
    Tuesday, January 11, 2011 9:56 PM
    Answerer