I'm stuck, so stuck I'm not even sure what to google or put in the subject, so sorry for that.
I've got a requirement which is simple in TSQL but can't figure out how to do it in SSAS, basically show me the purchase history for all contacts who have bought a specific product.
Simplified I have a factTable of ContactID,ProductID,Quantity,Value and dimensions of dimContact, dimProduct
My train of thought is I need to filter dimContact based on values in factTable but not sure how.
I'm sure I just need to be pointed in the right direction to get me out of my thought rut.
Thanks and apologies if this is a dumb post.