I need help with a simple MDX query.
Suppose I have a measure group linked to a fact table called Flights, which records air traffic information.
There are some attributes in that fact table:
FlightTime (how many minutes to get from Destination to Arrival)
Then I have two cube dimensions, one linked to DestinationCity, and one linked to ArrivalCity.
Those dimensions have a couple of attributes, including City, with memebers like 'Seattle', 'New York', 'Los Angeles', etc.
I need to write an MDX query that returns data from the FactFlights measure gropu where a city appears in EITHER the DestinationCity OR the ArrivalCity.
In TSQL this would be trivial.
DestinationCity = 'Seattle'
ArrivalCity = 'Seattle'
Any help/guidance would be greatly appreciated.