Her ses et eksempel på hvordan man beregner kumlative værdier over en periode
WITH
MEMBER MEASURES.[Sales To Date] as '
SUM( {[Time].CurrentMember.Level.Members}.Item(0)
: Time.CurrentMember,[Measures].[Sales Count])'
MEMBER MEASURES.[Sales Year To Date] AS '
SUM(YTD([Time].CurrentMember),[Measures].[Sales Count])'
MEMBER MEASURES.[Sales Quarter To Date] as '
SUM(QTD([Time].CurrentMember),[Measures].[Sales Count])'
SELECT
{[Measures].[Sales Count],
[Measures].[Sales To Date],
[Measures].[Sales Quarter To Date],
[Measures].[Sales Year To Date]} ON ROWS,
DESCENDANTS([Time], , LEAVES) ON COLUMNS
FROM
[Sales]
