September 12, 2019 at 10:54 am
Hi all,
I am new to MDX and I have already tried Google to find a solution for my query but didn't get any answer by myself.
For the use case, I have a role-play dimension (geography), a customer and store. Geography is used both in customer and store.
I want to figure out, how many people take effort to drive a long distance to get to the store.
In SQL, I would just use a WHERE condition with store.location <> customer.location.
How do I do it in MDX? I used the Cube Browser from SMSS but there no GUI solution for that. I tried Excel Pivot but I couldn't do it there, either.
Thanks for your help!
Sven
September 13, 2019 at 11:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
September 17, 2019 at 1:10 pm
There's not a lot of information here. But my first thought is to set up a cross reference fact table at the granularity of customer location and store location with the miles already determined. As this is non-additive, however, that's going to introduce some complexities.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy