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