Skip to Content
0
May 17, 2016 at 09:56 PM

Logic script to convert Periodic to YTD not considering Zero value records

28 Views

Hi All,

I am writing a Logic script (also tried using WHEN_REF_DATA = MASTER_DATA in between XDIM_MEMBERSET (to restrict scope and WHEN ...ENDWHEN construct

If there is a record for period 2015.FEB with value Zero, then it is not writing any new record for that .. But if the value exists for all the periods, this logic script works and creates a new record with the cumulative value

*XDIM_MEMBERSET ACCOUNT = 880100

*XDIM_MEMBERSET COMPANY = 100000

*XDIM_MEMBERSET INTERCO = I_NONE

*XDIM_MEMBERSET PC = P1020

*WHEN_REF_DATA = MASTER_DATA

*WHEN AUDITTRAIL

*IS PLAN_M

*WHEN TIME

*IS 2015.JAN

*REC(EXPRESSION = [TIME].[2015.JAN] ,TIME = 2015.JAN,AUDITTRAIL = REG_ADJ, PC = P1020)

*ENDWHEN

*WHEN TIME

*IS 2015.FEB

*REC(EXPRESSION = [TIME].[2015.JAN] + [TIME].[2015.FEB] ,TIME = 2015.FEB,AUDITTRAIL = REG_ADJ, PC = P1020)

*ENDWHEN

*WHEN TIME

*IS 2015.MAR

*REC(EXPRESSION = [TIME].[2015.JAN] + [TIME].[2015.FEB] + [TIME].[2015.MAR],TIME = 2015.MAR,AUDITTRAIL = REG_ADJ, PC = P1020)

*ENDWHEN

*WHEN TIME

*IS 2015.APR

*REC(EXPRESSION = [TIME].[2015.JAN] + [TIME].[2015.FEB] + [TIME].[2015.MAR] + [TIME].[2015.APR],TIME = 2015.APR,AUDITTRAIL = REG_ADJ, PC = P1020)

*ENDWHEN

*ENDWHEN


Many Thanks

Krishna