0 Replies Latest reply: Jun 16, 2009 10:05 PM by Thiagu Bala RSS

BPC LOOKUP Script logic

Thiagu Bala
Currently Being Moderated

I have created script logic which needs to read Qty from a different application and use the value in the current application calculation. Need to generate a new line with KF_TYPE="CalcQty" for each record of KF_TYPE='UNITCOST"

 

 

 

Note : Appset1: ACTIVITY_COST,  got 3 records of KF_TYPE = CalcQty

         Appset2: SALESORG_PLAN, Got 1 record for Sales Org "FKS1". So expecting to generate 3 new lines in App1 of KF_TYPE = CalcQty. The logic is reading 3 records and also reading the 2 records for the lookup program but not writing any.

 

*XDIM_MEMBERSET  KF_TYPE = UnitCost,CalcQty

*XDIM_MEMBERSET P_Entity = HQ

*XDIM_MEMBERSET P_DataSrc = SAP,INPUT

*XDIM_MEMBERSET Category = PLAN

*XDIM_MEMBERSET Materials = 10131

*XDIM_MEMBERSET TIME = 2009.JUN

 

 

*LOOKUP SALESORG_PLAN

*DIM TIME = "2009.JUN"

*DIM P_SALESORG = "FKS1"

*DIM P_DATASRC = "INPUT"

*DIM MATERIALS="10131"

*DIM MEASURES="PERIODIC"

*DIM TOTALQTY:KF_TYPE = "CalcQty"

*ENDLOOKUP

 

 

*DESTINATION_APP=ACTIVITY_COST

*WHEN  KF_TYPE

*IS "UnitCost"

REC(EXPRESSION=%VALUE%LOOKUP(TOTALQTY), KF_TYPE="CalcQty")

*ENDWHEN

*COMMIT

 

Any suggestions?

Actions