Hi everyone,
Who knows how to write a MDX to do basket analysis based on cube?
Thanks
Hello! I think that this is a task for the distinct count aggregation method on the measure you have choosen,
You have also the option to work with data mining in SSAS2005 for this analytic topic.
HTH
Thomas Ivarsson
|||Incase if you use Predictive Modelling algorithm in datamining for Market Basket Analysis, Use DMX to achieve this.
Thanks
Subhash Subramanyam
|||Sacha has just done a really good blog on this:
http://blogs.adatis.co.uk/blogs/sachatomey/archive/2007/08/22/basket-analysis-using-analysis-services-2005.aspx
HTH
Tim
没有评论:
发表评论