MDX query: how to use the unequal operator between different attributes

  • 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!


  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • 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 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply