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