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?