MDX Question
Posted: Fri Jul 16, 2010 4:55 pm
All,
This may be a straight MDX question or it may end up being a forcing a design change. Either suggestion is fine, as long as the response is relevant.
I have a cube with some shopping activity in it. The measures contains a CustomerID with the aggregation set to Distinct Count, along with Sales$'s and ItemQty. I also have all the standard dimensions present: Time, Stores, Products. I do not currently have a customer dimension.
What I need to do is create a view into the data where I can report on "cross-shopping" between stores. That is, I need to show a grid with a list of Stores on both axes and the intersection showing me how many customers shopped in both stores.
I'm thinking I might need to put Customers in a dimension, but would like your ideas.
Thanks, in advance...
This may be a straight MDX question or it may end up being a forcing a design change. Either suggestion is fine, as long as the response is relevant.
I have a cube with some shopping activity in it. The measures contains a CustomerID with the aggregation set to Distinct Count, along with Sales$'s and ItemQty. I also have all the standard dimensions present: Time, Stores, Products. I do not currently have a customer dimension.
What I need to do is create a view into the data where I can report on "cross-shopping" between stores. That is, I need to show a grid with a list of Stores on both axes and the intersection showing me how many customers shopped in both stores.
I'm thinking I might need to put Customers in a dimension, but would like your ideas.
Thanks, in advance...