Home Forums Data Warehousing Strategies and Ideas help to design a Cube that shows me all purchases for those who bought a given product RE: help to design a Cube that shows me all purchases for those who bought a given product

  • Hi Giles,

    I misinterpreted your meaning of 'purchase history for all contacts who have purchased a specific product' - i thought you meant show me who had purchased this product.

    Examples of what you can google is "SSAS market basket analysis". You can do this (MBA) using the data mining functionality within SSAS and since around excel 2010 (i think) you can use the excel addins to make this easier. It's a classic requirement, where people typically use "who bought Diapers & Beer" in the grocery store as their example 🙂

    Steve.