SAP BPC script logic: dimension member property use

[Former Member]

Hello Experts,

This my dimension members mapping

Cost Center BON_CC Func_Area Account

100 500 1 bonus

500 5 bonus

I am doing some calculation which posts the value in Account Bonus. Now, I have a condition in logic script which asks to save the calculated values in BON_CC. For example: Bonus calculated for 100 and 200 Cost Center will be posted to theer associated BON_CC i.e. 500

I also want this Bonus to go to the functional area (5) which is associated with Cost Center 500.

So, my script looks like:

*REC(EXPRESSION............)ACCOUNT=BONUS,COSTCENTER=COSTCENTER.BONUS_CC.FUNCTIONAL AREA=COSTCENTER.FUNC_AREA)

And my result is:

Account func_area CostCenter

Bonus 1 500

Bonus 5 500

So, the calculated value is getting posted to both the functional areas (functional area mapped with Cost Center as well as Bonus Cost Center). However, I want the results only on functional mapped to bonus cost center which is 5 in this example.

Kindly, help.

Regards,

Richa Pathak

[Former Member]

One possibility I can think of is to create a property called BONUS_FA in the current mapping and then the calculation can be posted to corresponding BONUS_FA mapped with the Cost Center_Bonus dimension.

[Former Member]

Dear Vadim,

Kindly, assist.

[former_member186338]

"I will NEVER answer to the question with images inserted using "Insert File" instead of correct "Insert Image"!"

I do not see any image in your posts! Look on other members of the Community - do you see a difference?

Also, don't attach code text, insert it directly using "Code" button. Try to be professional...

[Former Member]

Also, attached the whole script logic.bon-calc.txt

bon-calc.txt

[Former Member]

Sorry...I have now inserted the image using insert image.

[Former Member]

capture.png attached for dimension member mapping

[former_member186338]

I will NEVER answer to the question with images inserted using "Insert File" instead of correct "Insert Image"!