Get property of a property in Script logic for sap bpc

[Former Member]

Hello Experts,

I have a typical problem....

I am having a value in a DRIVER R_001 for some statistical GL account and say entity is WR01

now i want to post this amount from to an entity WR02, logic to derive this is as below

R_001 driver has property profit_center, and profit_center is a dimension which has a property as entity which would be WR02.

now how do i achieve this in script logic.?

[Former Member]

SAP BW 7.4 SP 15

BPC 810 SP 009

Engine is JAVASCRIPT (didnt get the error as said)

Model is for Financial Planning with dimension as DRIVER,ENTITY, PROFIT_CTR, ACCOUNT and other necessary.

Driver has a property as PC (in which the profit center is maintained)

PROFIT_CTR has property as COMP( in which entity is maintained)

Below is the Data

Account DRIVER ENTITY PROFIT_CTR AMOUNT

ACC1 R001 WR01 WR0112 100

Now using the script can i post this to

ACC1 R001 WR01 WR0212 100

Logic for this change in Entity is as below

DRIVER Master data

ID PC

R001 WR0212

PROFIT_CTR Master data

ID COMP

WR0212 WR02

As you can see this the entity is derived from driver (R001)-->PC(WR0212)-->PROFIT_CTR(WR0212)-->COMP(WR02)

I hope this helps

[Former Member]

Posting with some format change in the data section of the example

SAP BW 7.4 SP 15

BPC 810 SP 009

Engine is JAVASCRIPT (didnt get the error as said)

Model is for Financial Planning with dimension as DRIVER,ENTITY, PROFIT_CTR, ACCOUNT and other necessary.

Driver has a property as PC (in which the profit center is maintained)

PROFIT_CTR has property as COMP( in which entity is maintained)

Below is the Data

Account - DRIVER - ENTITY- PROFIT_CTR - AMOUNT

ACC1- R001- WR01- WR0112- 100

Now using the script can i post this to

ACC1- R001- WR01- WR0212- 100

Logic for this change in Entity is as below

DRIVER Master data

ID- PC

R001- WR0212

PROFIT_CTR Master data

ID- COMP

WR0212- WR02

As you can see this the entity is derived from driver (R001)-->PC(WR0212)-->PROFIT_CTR(WR0212)-->COMP(WR02)

[former_member186338]

"Account - DRIVER - ENTITY- PROFIT_CTR - AMOUNT

ACC1- R001- WR01- WR0112- 100

Now using the script can i post this to

ACC1- R001- WR01- WR0212- 100"

I see no change in ENTITY! WR01 in both lines!

[Former Member]

"Account - DRIVER - ENTITY- PROFIT_CTR - AMOUNT

ACC1- R001- WR01- WR0112- 100

Now using the script can i post this to

ACC1- R001- WR02- WR0212- 100"

Sorry my mistake.....

I want to use this in Datamanger package

[former_member186338 · Accepted solution]

Something like:

*XDIM_MEMBERSET DRIVER=R001
*WHEN DRIVER
*IS *
*REC(EXPRESSION=%VALUE%,PROFIT_CTR=DRIVER.PC,ENTITY=DUMMY)
*ENDWHEN

*XDIM_MEMBERSET ENTITY=DUMMY
*WHEN DRIVER
*IS *
*REC(EXPRESSION=%VALUE%,ENTITY=PROFIT_CTR.COMP)
*REC(EXPRESSION=0) //clear DUMMY ENTITY
*ENDWHEN

First write to dummy ENTITY with correct PROFIT_CTR, then to correct entity.

[Former Member · Accepted solution]

it worked..... As always... thanks a lot

[former_member186338]

Or I can provide you an answer like your question:

Use LOOKUP and 2 writes using temp entity

[Former Member]

please cehck the comment section of the question

I have tried to explain it in more details

[former_member186338]

4. Clearly identify the purpose of the script: to run as default.lgf or to be launched by DM package (different calculation logic!). Please, ALWAYS answer this question!!!!

[former_member186338]

Please! Read https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

And provide the required info! I really don't want to ask endless questions to understand what do you want to achieve...