Skip to Content
0
Former Member
Jan 09, 2012 at 08:27 AM

How to Avoid Override of values

52 Views

Hi,

wat should i mention in my rec statemnt to avoid override of value...

suppose m sending data frm revenue app to finance app for the first time...

(entering data against 5 product out of 10 and sending it to db)

if i again do this exercise for 2nd time (for the rest 5 product)...the data gets override...my p n l report shows me the new value..

which i want to avoid.

i want the values to get sumed up..

Immediate response will b appreciated..

Thanks in advance

*DESTINATION_APP = FINANCE
*XDIM_MEMBERSET P_Category = budver1
*XDIM_FILTER P_ENTITY = [P_ENTITY].properties("GROUPTYPE")="T"
*XDIM_FILTER P_DistChannel = [P_DistChannel].properties("GROUP")="REVENUE"
*XDIM_MEMBERSET P_RevAccount = 3000000 ,3000002 , 4000000
*XDIM_FILTER P_PRODUCTS = [P_PRODUCTS].properties("TRANSFER")="Y"
*XDIM_FILTER P_COUNTRY = [P_COUNTRY].properties("TRANSFER")="Y"
*SKIP_DIM = P_PLANT,P_VENDOR,P_RevInpCurrency
*RENAME_DIM P_Products = P_CostCenter, P_Country = P_Region, P_RevAccount =P_COA
*XDIM_MEMBERSET RPTCURRENCY = LC, INR,EUR,GBP



*WHEN P_REVACCOUNT 
*IS "3000000" 
*REC(FACTOR =1, P_COUNTRY=P_COUNTRY.FINACCOUNT , P_PRODUCTS = P_PRODUCTS.FINACCOUNT, P_REVACCOUNT = P_REVACCOUNT.FINACCOUNT)
*REC(FACTOR =1, P_COUNTRY=P_COUNTRY.FINACCOUNT , P_PRODUCTS = P_PRODUCTS.FINACCOUNT, P_REVACCOUNT = P_REVACCOUNT.FINACCOUNT2)
*REC(FACTOR =1, P_COUNTRY=P_COUNTRY.FINACCOUNT , P_PRODUCTS = P_PRODUCTS.FINACCOUNT, P_REVACCOUNT = P_REVACCOUNT.FINACCOUNT4)

*ENDWHEN

*WHEN P_REVACCOUNT 
*IS "3000002" 
*REC(FACTOR =1, P_COUNTRY=P_COUNTRY.FINACCOUNT , P_PRODUCTS = P_PRODUCTS.FINACCOUNT, P_REVACCOUNT = P_REVACCOUNT.FINACCOUNT)
*REC(FACTOR =1, P_COUNTRY=P_COUNTRY.FINACCOUNT , P_PRODUCTS = P_PRODUCTS.FINACCOUNT, P_REVACCOUNT = P_REVACCOUNT.FINACCOUNT2)
*REC(FACTOR =1, P_COUNTRY=P_COUNTRY.FINACCOUNT , P_PRODUCTS = P_PRODUCTS.FINACCOUNT, P_REVACCOUNT = P_REVACCOUNT.FINACCOUNT4)

*ENDWHEN