Sequence Clustering in Excel DM Add-In 2013, Cannot Set Sequence Key


  • Hi Everyone,

    I was attempting to run a Sequence Clustering DM in Excel and I tried to get around the need for a nested table by flattening my normalized Sales Order and Sales Order Line Item into a single table through a query.

    However, when I go to create the Mining Structure in Excel, there is no option for setting the Key Sequence. If I go try to add a Mining Model to a mining Structure, Sequence Clustering is an option but I cannot proceed unless I set the Key Sequence when I am building the Mining Structure.

    Does MS Excel DM support Sequence Clustering analysis? Or is there a workaround within Excel?



    Friday, December 13, 2013 10:34 PM


All replies