Data management Mapping - Map parent to a different segment

Summary

Map same dimension members to different GL segments in data management

Content

The hierarchy structure of entity dimension in our EPBCS solution is designed such that LOB's (Line of business) roll up to entity. However, in GL, LOB and Entity are two different segments.

We are trying to push budget data from EPBCS to GL via data management. We were able to easily map Line of business in EPBCS with GL LOB segment. However, since in EPBCS entities are parents of LOB's, how can we map these entities with GL entity segment? Do we need to write Jython or SQL script?