Level 2 Sprint 2 Module to Module Aligning Dimensions Mapping
In one of the Sprint 2 activities, we need to reference data from one Module to another. To do this you must align the dimensionality of the Source Module to the Target Module. However the List dimension in the Source Module is a Parent of the corresponding dimension in the Target Module, requiring us to use an intermediary (SYS) module to align the source to the target.
How would you do that?
I have tried multiple variation of LOOKUP, and LOOKUP & SELECT however I continue to receive error messages.