ClassMethod %OnGetComputedMembers(pDimName As %String,
pHierName As %String,
pLevelName As %String,
ByRef pMemberList,
pRollupKey As %String = "",
ByRef pRange As %String = "") As %Status
ClassMethod %OnGetComputedMembers(pDimName As %String, pHierName As %String, pLevelName As %String,
ByRef pMemberList, pRollupKey As %String = "", ByRef pRange As %String = "") As %Status
{
If (pDimName="AgeBuckets") {
If (pLevelName="Years") {
// $LB(MDX,Name,Key)
Set pMemberList($I(pMemberList)) =
$LB("%OR([DateOfSale].[Actual].[DaySold].[NOW-1y-1d]:[NOW])","1 year(s)","1")
Set pMemberList($I(pMemberList)) =
$LB("%OR([DateOfSale].[Actual].[DaySold].[NOW-2y-1d]:[NOW-1y])","2 year(s)","2")
Set pMemberList($I(pMemberList)) =
$LB("%OR([DateOfSale].[Actual].[DaySold].[NOW-3y-1d]:[NOW-2y])","3 year(s)","3")
Set pMemberList($I(pMemberList)) =
$LB("%OR([DateOfSale].[Actual].[DaySold].[NOW-4y-1d]:[NOW-3y])","4 year(s)","4")
Set pMemberList($I(pMemberList)) =
$LB("%OR([DateOfSale].[Actual].[DaySold].[NOW-5y-1d]:[NOW-4y])","5 year(s)","5")
Set pMemberList($I(pMemberList)) =
$LB("%OR([DateOfSale].[Actual].[DaySold].[NOW-6y-1d]:[NOW-5y])","6 year(s)","6")
Set pMemberList($I(pMemberList)) =
$LB("%OR([DateOfSale].[Actual].[DaySold].[NOW-7y-1d]:[NOW-6y])","7 year(s)","7")
}
}
Quit $$$OK
}