开发者

Various Moving Annual Totals in an SSAS Cube

开发者 https://www.devze.com 2022-12-10 02:22 出处:网络
This is how I am creating my moving totals as columns in my cube: MATTY (Moving Annual Total This Year)

This is how I am creating my moving totals as columns in my cube:

MATTY (Moving Annual Total This Year)

SUM ( { [Time Period].[Month].CURRENTMEMBER.Lag(12) : [Time Period].[Month].CURRENTMEMBER }, [Measure开发者_JS百科s].[MeasureColumnName])

MATLY (Moving Annual Total Last Year)

SUM ( { [Time Period].[Month].CURRENTMEMBER.Lag(24) : [Time Period].[Month].CURRENTMEMBER.Lag(12) }, [Measures].[MeasureColumnName])

How do I do the following?

YTDTY (Year To Date This Year)

YTDLY (Year To Date Last Year - up to same date as today)


I suggest you have a look at the PeriodsToDate and YTD MDX functions on MSDN. Is there something more than those that you need?

0

精彩评论

暂无评论...
验证码 换一张
取 消