I need help with an MDX query.
I have a fact table to hold product events (ProductId, AreaId, EventId, EventStartDateId, EventEndDateId).
I have a Product dimension (Product1, Product2, Product3).
I have an Event dimension (EventType1, EventType2, EventType3).
I have an Area dimension with State-City-Zip hierarchy.
I have a Time dimension with St...