Friday 26 April 2013

SSAS Cube Calculations (YTD, BTD, PY, PYTD)


Actual YTD
AGGREGATE ( PERIODSTODATE( [Financial Date].[Calendar FY-M].[Financial Year],[Financial Date].[Calendar FY-M].CurrentMember ), [Measures].[Actual] )

Actual BTD
AGGREGATE ( PERIODSTODATE( [Financial Date].[Calendar FY-M].[(All)],[Financial Date].[Calendar FY-M].CurrentMember ), [Measures].[Actual] )

Actual PY
( ParallelPeriod ( [Financial Date].[Calendar FY-M].[Financial Year], 1, [Financial Date].[Calendar FY-M].CurrentMember ), [Measures].[Actual] )

Actual PYTD
AGGREGATE ( PERIODSTODATE( [Financial Date].[Calendar FY-M].[Financial Year]
    , ParallelPeriod ( [Financial Date].[Calendar FY-M].[Financial Year], 1, [Financial Date].[Calendar FY-M].CurrentMember ) )

No comments:

Post a Comment