Your UX is waiting ...interact, engage, explore in Las Vegas at CloudWorld 2023

Learn more
Data management Mapping - Map parent to a different segment — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Data management Mapping - Map parent to a different segment

Received Response
36
Views
4
Comments
edited Oct 14, 2019 4:24AM in Enterprise Data Management 4 comments

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!