Counting 'in-flight' events in MDX (by Mosha Pasumansky)
Time dimension has special meaning in OLAP and DW. The classic problems involve looking at previous period, parallel period, computing moving averages and running sums. Today we will look into less common, but nevertheless interesting problem of 'in-flight' events. This scenario arises when there is more than one date/time attribute associated with the fact. For example, for the marketing campaign we can have creation date, start and end date for the campaign; for airplanes there is departure and arrival time; in Adventure Works for each order we track order creation date, order shipping date and order delivery date.
Tags: mdx