cancel
Showing results for 
Search instead for 
Did you mean: 

How to Avoid Override of values

Former Member
0 Kudos
87

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

Accepted Solutions (0)

Answers (1)

Answers (1)

krishna_priya1
Contributor
0 Kudos

Try below code and let me know if it works.


*WHEN P_REVACCOUNT 
*IS "3000000" 
*REC(EXPRESSION =%VALUE% +([P_COUNTRY].[P_COUNTRY.FINACCOUNT],[P_PRODUCTS].[P_PRODUCTS.FINACCOUNT],[P_REVACCOUNT].[P_REVACCOUNT.FINACCOUNT])  , P_COUNTRY=P_COUNTRY.FINACCOUNT , P_PRODUCTS = P_PRODUCTS.FINACCOUNT, P_REVACCOUNT = P_REVACCOUNT.FINACCOUNT)
 *ENDWHEN

Hope this helps.