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

  • svenflock

    Old Hand

    Points: 366

    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

  • Site Owners

    SSC Guru

    Points: 80385

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

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

  • RonKyle

    SSC-Dedicated

    Points: 31457

    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