I am presently using the following script to calculate the MAT :
CREATE MEMBER CURRENTCUBE.[Measures].[LatestMAT] AS
SUM([Time].[Time].currentmember.lag(13) : [Time].[Time].currentmember,[Measures].[Volume])
Could someone please tell me if there's any other more efficient way to do this?
MAT or moving annual total is calculated as the sum of volume of every time period from the present month to a year back. (in my case, i have 13 periods in a year. so that is 13 periods back)
View Complete Post