DESTINATION APP IN SAP BPC NW 10.0

[former_member591016]

Hi Experts,

I am trying to transfer data from one model to another model in SAP BPC 10.0 NW. Script logic written in source Model for that purpose is:

*XDIM_MEMBERSET AUDITTRAIL = Input

*XDIM_MEMBERSET FLOW = Closing

*XDIM_MEMBERSET P_ENTITY = SIL

*XDIM_MEMBERSET RPTCURRENCY = LC

*SELECT (%SGRP%,RIGHT([ID],6),CUSTOMER_SALES,[PROP]=DUM)

*XDIM_MEMBERSET CUSTOMER_SALES = %SGRP%

*XDIM_MEMBERSET ACTIVITY_SALES = ACT_112

*DESTINATION_APP = SALES_PLANNING_SIL_2

*SKIP_DIM = PLANT

*RENAME_DIM CATEGORY1 = CATEGORY, CUSTOMER_SALES = CUSTOMER_SALES_2

*FOR %CUST% = %SGRP%

*WHEN ACTIVITY_SALES

*IS ACT_112

*REC(EXPRESSION=%SIGNEDDATA%)

*ENDWHEN

*NEXT

*COMMIT

Logic is getting validated but not getting any result in destination Model. Kindly Guide me as I am new to SAP BPC.

Thanks in Advance

[former_member186338]

Hi Rakhi,

Does the script really validates???

Incorrect syntax of *SELECT:

*SELECT (%SGRP%,RIGHT([ID],6),CUSTOMER_SALES,[PROP]=DUM)

Incorrect REC syntax:

*REC(EXPRESSION=%SIGNEDDATA%)

Please, read help on both!

DESTINATION_APP keyword in BPC NW 10 is working only for the next WHEN/ENDWHEN loop, but you have FOR/NEXT loop generating number of WHEN/ENDWHEN loops... Use DESTINATION_APP inside FOR/NEXT.

Vadim

[former_member591016]

Hi Vadim,

Thanks for your early reply.

Yeah my script is getting validated. In my scenario I need to transfer values from selected members of source model. IDs of which are eg. D_SG_CCP in source model, whereas in destination model it is SG_CCP. Thats why I had to use MDX function in select statement.

And I also tried in REC Statement *REC (EXPRESSION=%VALUE%)  and using DESTINATION _APP inside FOR/NEXT, but not getting result.

One thing I need to confirm is that I wrote this logic in DEFAULT LOGIC of source model and nothing in destination Model. Is there any thing which is missing.

Thanks

[former_member186338]

Hi Rakhi,

Sorry, but the script provided in your post will NEVER validate in BPC NW, because of the issues I already mentioned.

And because RIGHT of something is not supported in SELECT (only some property, including [ID]), then you have to use different approach - create some property in CUSTOMER_SALES and fill it with the corresponding member of SG_CCP model dimension. Then in REC you can use this property as target override.

Vadim