Property of another dimension on Script logic SAP BPC 10.1

[Former Member]

Hi experts,

I need to make a script logic that copies data from one model to another.

In the destination model I have the dimension "SEGMENT". In the source model I don´t have this dimension, the dimension that I have is Cost Center who has the property of Profit Center.  There´s a dimension Profit Center (which I don´t use in my source model) that has the Segment property.

How can I make a Script Logic that copy the segment property of the profit center dimension to the dimension Segment of the destination Model?

For example, the cost center C8415 has the property of profit center: B14. In the Profit Center dimension, the dimension member B14 has the segment property: S300.  I want in the source model that the dimension Segment reveals the S300.

[Former Member · Accepted solution]

Hello Maria,

For copying data from one model to another you can use DESTINATION_APP script.

Please refer the below link.

http://sapassets.edgesuite.net/sapcom/docs/2015/08/6cdcaf53-557c-0010-82c7-eda71af511fa.pdf

Thanks!!

[former_member186338]

"There´s a dimension Profit Center (which I don´t use in my source model) that has the Segment property." - you can't use it to get a segment!

In the costcenter dimension create a new property segment and fill it with the required segment. Then use this property as it's explained in the destination_app help: *DESTINATION_APP - SAP Business Planning and Consolidation, version for SAP NetWeaver - SAP Library

"*ADD_DIM P_DATASRC=INPUT, MARKET = PRODUCT:MARKET"

[Former Member]

With a script logic can I make a derivation of the segment property?

The cost center dimension has a Profit Center property, what I want to do is create the Segment property in the cost center dimension. What I want to do is a script logic that searchs the property Profit Center of the Cost Center dimension in the Profit Center dimension, when it finds it, it must copy it's Segment Property and paste it in the Segment property of the Cost Center.

Another possible way that I think is load the Segment property of the cost center with a flat file, but this option is very manual.

[akos_beres]

Maria,

To my knowledge you can't use script logic to populate master data properties nor can you use characteristic derivation from another model. (unless the data that you are running a calculation on includes the profit center dimension than you can reference the property)

You need to find a way to update the cost center's segment property when the cost center dimension is updated. Maybe have your BW guys enhance the Cost center infoobject to include the segment characteristic and then when cost centers update runs, map the InfoObject characteristic to the property in BPC.

Hope this helps!

Akos

[former_member186338]

"With a script logic can I make a derivation of the segment property?"

I have already told you - you CAN'T do it!

"What I want to do is a script logic that searchs the property Profit Center of the Cost Center dimension in the Profit Center dimension, when it finds it, it must copy it's Segment Property and paste it in the Segment property of the Cost Center."

You can't change property using script!

Vadim

[former_member186338]

"Maybe have your BW guys enhance the Cost center infoobject to include the segment characteristic" - to my mind it's a correct way!

The alternative is the badi that will update the property....