Consider a scenario where we have two customers account with the below Financial dimension values:

 

 

BusinessUnit

CostCenter

Department

Customer1

001

007

024

Customer2

002

011

031

 Now, let say I have a requirement to replace only CostCenter financial dimension for Customer1 with Customer2 if it is not empty. The resulting Financial dimension for Customer1 would become BusinessUnit: 001, CostCenter: 011 and Department: 024.

 Below is the code to implement the above scenario:

Image

I have added the comments on the code for better understanding. 

Enjoy!!

 

Advertisements