Listing 2: Calculated Members in Solution 2

// [End Count] definition
MEMBER Measures.[New End Count] AS
// At [Calendars].[Calendars].[Calendar Group].&[Fiscal], go to first year.
IIF([Calendars].[Calendars].CurrentMember.Parent.Properties("KEY") = "3"
// TRUE
,
([Calendars].[Calendars].[Calendar Group].&[Fiscal].FirstChild ,[Measures].[Hire Count])
+ ([Calendars].[Calendars].[Calendar Group].&[Fiscal].FirstChild, [Measures].[Termination Count])
+ ([Calendars].[Calendars].[Calendar Group].&[Fiscal].FirstChild, [Measures].[Transfer Count])
// FALSE
,
Measures.[New Begin Count]
+ [Measures].[Hire Count]
+ [Measures].[Termination Count]
+ [Measures].[Transfer Count]
)

// ******* BEGIN CALLOUT A *******
// [Begin Count] definition
MEMBER Measures.[New Begin Count] AS
IIF([Calendars].[Calendars].CurrentMember.FirstSibling.Properties("ID") =
[Calendars].[Calendars].CurrentMember.Properties("ID")
// TRUE
,
([Calendars].[Calendars].CurrentMember.Parent, Measures.[New Begin Count])
// FALSE
,
([Calendars].[Calendars].CurrentMember.PrevMember, Measures.[New End Count])
)
// ******* END CALLOUT A *******