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

  • So, you have a cube right? Assuming you do, then using Excel (really just to save you the time of writing the MDX yourself), can you get the result you desire by putting Time (month, days whatver) in the columns, Customers on the rows, quantity and/or value in the data part of the crosstab, and then put the product name/id in the Filters, and then select a single (or multiple) products?

    Steve.