Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Script logic to subtract values nwbpc10

Hi Experts,

I am new to this script logics. and I am trying to implement a script logic to subtract values from one period to another period. for Ex

    Time          2014.p09            2014.P09      2014.P10

    Category    Decfcast            Actual           Q4f

    Audittrail     Input                  Sap-BW        Input

  Result          100                     70               30(100-70)

From the above, i want to post the differences between Decfcst and actual into Q4f forecast.

First i just take some static periods and try the below code,however this script failed to do subtract , i got the value 100 instead of  30 ,in 2014.P10.

*XDIM_MEMBERSET ACCOUNT = BAS(BUD2197)

*XDIM_MEMBERSET TIME=2014.P09

*XDIM_MEMBERSET CATEGORY=DECFCAST,ACTUAL

*XDIM_MEMBERSET RPTCURRENCY=LC

*XDIM_MEMBERSET AUDITTRAIL=SAP-BW,Input

*WHEN ACCOUNT

*IS *

*WHEN CATEGORY

*IS DECFCAST

*REC(EXPRESSION=%VALUE%-([CATEGORY].[ACTUAL],[TIME].[2014.P09]),TIME=2014.P11,CATEGORY=Q4F,AUDITTRAIL=Input)

*ENDWHEN

*ENDWHEN

PFA for package log calculation.

Please help

Former Member
replied

But I recommend to use different logic with aggregation in target:

*XDIM_MEMBERSET ACCOUNT = BAS(BUD2197)

*XDIM_MEMBERSET TIME=2014.P09

*XDIM_MEMBERSET CATEGORY=DECFCAST,ACTUAL

*XDIM_MEMBERSET RPTCURRENCY=LC

*XDIM_MEMBERSET AUDITTRAIL=SAP-BW,Input

*WHEN CATEGORY

*IS DECFCAST

*WHEN AUDITTRAIL

*IS Input

*REC(EXPRESSION=%VALUE%,TIME=2014.P10,CATEGORY=Q4F)

*ENDWHEN

*IS ACTUAL

*WHEN AUDITTRAIL

*IS SAP-BW

*REC(EXPRESSION=-%VALUE%,TIME=2014.P10,CATEGORY=Q4F,AUDITTRAIL=Input) //Negative!

*ENDWHEN

*ENDWHEN

Vadim

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question