Could you please advise me on signeddata accumulation using Script Logic in BPC 7.5 NW.
I want to accumulate the signeddata as below:
Account | ENTITY | TIME | Signeddata
Acc1, ENTITY1, 2011.JAN, 7
Acc1, ENTITY1, 2011.FEB, 15
Acc1, ENTITY1, 2011.MAR, 22 <----Should accumulate the JAN and FEB and store in MAR.
Please help me and thanks in advance
Edited by: S.KumarBPC on Mar 4, 2012 1:38 PM
Idea is to have both month in the scope and assign target month.
*XDIM_MEMBERSET TIME = 2011. JAN, 2011.FEB
*REC(FACTOR=1, TIME = 2011.MAR)
When you use the WHEN statement, if you have multiple sources and a single destination, then the values of the source members get accumulated in the destination member. This is what has been illustrated in Gersh's code.
Login to follow, like, comment, share and bookmark content.