kbab95
Valued Member
Points: 59
More actions
September 25, 2015 at 3:40 pm
#321494
Hi,
How can i determine products purchased together based on a transaction id in my cube?
E.g. calculate the top 2 products sold together assuming every transaction sells exactly 2 products.
Using mdx... Any help would be appreciated.
PB_BI
SSCoach
Points: 17461
September 26, 2015 at 6:05 am
#1829694
MDX isn't magic, you will need to do the groundwork in the structure of your cube first. My thought is that you will need to utilise a many to many join.
Have a read of the following first:
http://www.sqlbi.com/articles/many2many/
Then move on to this:
http://blog.crossjoin.co.uk/2014/09/12/counting-customers-who-have-bought-all-selected-products/
For fairness' sake, you could achieve what you need with a distinct count, but you will take a performance/manageability hit:
https://technet.microsoft.com/en-us/library/aa902637(v=sql.80).aspx
Have fun.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply