Post reply

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

  • September 12, 2019 at 10:54 am

    #3679427

    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

    #3679762

    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

    #3680698

    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