Script logic to subtract values nwbpc10

[Former Member]

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

status log.txt.zip

[former_member186338]

You get 100 because you missed AUDITTRAIL here: ([CATEGORY].[ACTUAL],[TIME].[2014.P09])

Has to be:

([CATEGORY].[ACTUAL],[TIME].[2014.P09],[AUDITTRAIL].[SAP-BW])

And the scope was incorrect, has to be:

*XDIM_MEMBERSET CATEGORY=DECFCAST

*XDIM_MEMBERSET AUDITTRAIL=Input