Skip to Content
0
Jun 10, 2014 at 06:51 PM

Perform Dynamic Calculation using Script Logic

137 Views

Hi Experts,

The following table illustrates what I wanted to do: For ACCOUNT_A, I want to sum up DIM_ENTITY members for each node and send to a specific member for each node. For instance, I want to sum MEMBER A1,A2,A3, and save (value of 1+2+3=6) to MEMBER NODE_A_SUM. I think I can repeat the following scripts to do the job. However, it's too repetitive if I have 20 nodes. Also, there can be new nodes/members setup later on and will requre scripts modified. Is there a way to dynamically perform this calcuation?

You will notice that for ACCOUNT_B, the natural hierarchy aggregration 35% for NODE_A is not what I need in our business situation; instead it is a manual input. ACCOUNT_C is a formula account basically is the product of Account A and B. So for ALL Nodes, Account C will not be correct. The workaround is to setup Members to represent each Node and using scripts to sum up and save in those members.

*WHEN DIM_ACCOUNT

*IS ACCOUNT_A

*WHEN DIM_ENTITY

*IS MEMBERA1,MEMBERA2,MEMBERA3

*REC(FACTOR=1,DIM_ACCOUNT=NODE_A_SUM)

*ENDWHEN

*ENDWHEN

.........

.........

Version: NW BPC V10, SP15, Patch1

Thanks.

Ben

Attachments

Pic2.jpg (79.1 kB)