on 2012 Jan 09 8:27 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
5 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.