I'm trying to figure out if something is possible. Assume a simple fact table of sales $ and 2 dimensions, customers and products.
The requirement is, when a customer is selected in the customer dimension and a product is selected in the product dimension, any other customers that have sales for that product would also be selected. So if I select John Smith and product 1234, anyone
else that has purchased 1234 will also be selected in the customer dimension. Is this possible? I don't know a ton about mdx, I thought it was only for queries, but are there say an event I can capture when the user clicks on a customer and run some mdx to
select other customers that have also purchased that product? Or some other way if possible.
Thanks in advance.
View Complete Post