Skip to Content
0
Former Member
Nov 09, 2009 at 11:52 AM

BPC Moving Sales Planning Data from Sales Application to P&LApplication

115 Views

Hi

I am implementing an integrated Planning Scenarion in BPC MS 7 platform.

In the SALES PLANNING APPLICATION , i have a Sales Account Dimension, from where i am trying to move NET REVENUE & COGS TO P&L PLANNING APPLICATION. In that dimension i have a TRANSFER PROPERTY with value 'Y" update for the above 2 member id's.

The following Script is developed , which is passing the Validation:

*DESTINATION_APP=BP_PROFIT_LOSS

*SKIPDIM=PRODUCT

*RENAME_DIM SALESACCOUNT = Account

*XDIM_MEMBERSET Category <> ACTUAL

*XDIM_MEMBERSET PRODUCT = <ALL>

*WHEN SALESAccount.TRANSFER

*IS "Y"

*WHEN SALESAccount.PROFITLOSSACCT

*IS <> " "

*REC(EXPRESSION=%VALUE%,SALESACCOUNT=SALESACCOUNT.PROFITLOSSACCT,DataSrc="BP_SALESApp")

*ENDWHEN

*ENDWHEN

*COMMIT

BUT WHEN I AM CHECKING THE REPORT IN P&L APPLICATION WITH DATASRC & TIME IN COLUMNS & ACCOUNT IN ROWS, THERE IS NO DATA FOR BP_SALESApp FOR A GIVEN ACCOUNT & TIME.

Can anybody throw a light on the above.

Regards

Krish