I have a measure that is additive across all dimensions other than time.Essentially, in the time dimension, it computes the number of open bookings, so
what it should return for a given time slicing is the value of the booking at the Opening Period.
As a calculated measure, something like (OpeningPeriod([Time].[Day]), [Measures].[Open Bookings]) returns the measure i want correctly and deals with roll ups as well., as long as queries are not filtered by time.
For example, if the where clause has a date range, this calculation breaks down.
Does anyone know how to correctly compute the opening value that respects filtering on time dimension?