Skip to Content
0
Former Member
Jul 10, 2014 at 11:03 AM

Conditional Copy one to one

21 Views

Hi there,
I use BPC 7.5 NW SP 10
I want to copy the values ​​from last year to next year as follows:


I run my package 3 times out:
Step1: Budget BAS(current year) to Budget BAS(next year)
Step2: Counter BAS(current year) to Budget BAS(next year) (must overwrite if %value%<> 0 or <> "")
Step3: Actual BAS(current year) to Budget BAS(next year) (must overwrite if %value%<> 0 or <> "")

In dafault Copy Package that does not work, because with Counter or Actual values come ​​also 0 or "".


With Boolean'm not progressed.


Any idea?


Thanks in advance.
Alisher


//---priorization logic





//---My Package





//----My Script


*SELECT(%ERZ_FW%,"[ID]",EDM_PLANT,"[VART]=FW")

*SELECT(%ERZ_KW%,"[ID]",EDM_PLANT,"[VART]=KW")

*SELECT(%ERZ_DL%,"[ID]",EDM_PLANT,"[VART]=DL")

*SELECT(%ERZ_ST%,"[ID]",EDM_PLANT,"[VART]=ST")

//---

*XDIM_MEMBERSET EDM_ACCT = %EDM_ACCT_SET%

*XDIM_MEMBERSET EDM_DATASRC = %EDM_DATASRC_SET%

*XDIM_MEMBERSET EDM_OBJECT = %EDM_OBJECT_SET%

*XDIM_MEMBERSET EDM_PLANT = %ERZ_FW%,%ERZ_KW%,%ERZ_DL%,%ERZ_ST%

*XDIM_MEMBERSET EDM_REPCYCLE = KJ

*XDIM_MEMBERSET EDM_RPTCUR = EUR

*XDIM_MEMBERSET EDM_TARIFF = TID_NAS

*XDIM_MEMBERSET EDM_TIME = %EDM_TIME_SET%

*XDIM_MEMBERSET EDM_VIEW = %EDM_VIEW_SET%

*XDIM_MEMBERSET MEASURES = PERIODIC

//---

*WHEN_REF_DATA=TRANS_DATA

*WHEN EDM_VIEW

*IS BUDGET

*WHEN EDM_TIME.PERIOD

*IS JAN

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(1,%EDM_TIME_SET%))

*IS FEB

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(2,%EDM_TIME_SET%))

*IS MAR

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(3,%EDM_TIME_SET%))

*IS APR

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(4,%EDM_TIME_SET%))

*IS MAY

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(5,%EDM_TIME_SET%))

*IS JUN

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(6,%EDM_TIME_SET%))

*IS JUL

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(7,%EDM_TIME_SET%))

*IS AUG

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(8,%EDM_TIME_SET%))

*IS SEP

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(9,%EDM_TIME_SET%))

*IS OCT

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(10,%EDM_TIME_SET%))

*IS NOV

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(11,%EDM_TIME_SET%))

*IS DEC

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(12,%EDM_TIME_SET%))

*ENDWHEN

*ENDWHEN

*WHEN_REF_DATA=TRANS_DATA

*WHEN EDM_VIEW

*IS COUNTER

*WHEN SIGNEDDATA

*IS >0

*WHEN EDM_TIME.PERIOD

*IS JAN

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(1,%EDM_TIME_SET%))

*IS FEB

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(2,%EDM_TIME_SET%))

*IS MAR

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(3,%EDM_TIME_SET%))

*IS APR

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(4,%EDM_TIME_SET%))

*IS MAY

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(5,%EDM_TIME_SET%))

*IS JUN

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(6,%EDM_TIME_SET%))

*IS JUL

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(7,%EDM_TIME_SET%))

*IS AUG

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(8,%EDM_TIME_SET%))

*IS SEP

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(9,%EDM_TIME_SET%))

*IS OCT

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(10,%EDM_TIME_SET%))

*IS NOV

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(11,%EDM_TIME_SET%))

*IS DEC

*REC(EXPRESSION=%VALUE%,EDM_VIEW=BUDGET,EDM_DATASRC=COPY,EDM_TIME=TMVL(12,%EDM_TIME_SET%))

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT

Attachments