Pulling data from different BPC model in Script logic with changes to dimension

[Former Member]

We are on BPC 10.1 for Netweaver. Is there a way to use the destination_app in BPC script logic, and making changes to a dimension member in the process? We have 2 COPA models, and currently are using a load job to transfer the data from one to the other. SALES model has more product hierarchy detail (PH1-4) where we do our sales forecast and planning, and FINANCE has a summarized product hierachy level (PH1 or PH1-2) where we run allocations to get a full P&L. We use the same product dimension between the 2 models, but add FIN in front of the FINANCE model products. Is it possible to add FIN, and remove the last 5-9 characters at the end of the product dimension using the destination_app in BPC script logic?

[former_member186338 · Accepted solution]

In the product dimension you have to create a property FINPRODUCT and fill it for all SALES products with destination product with FIN prefix.

Then you can write to PRODUCT.FINPRODUCT.

Unfortunately, you can't perform string manipulation in script logic.

[Former Member]

Thank you, Vadim. Very helpful. Could you do this across different BPC environments?

[former_member186338]

No, destination_app can copy data only within single environment!

For different environments you have to develop custom logic badi. But what is the business case???