Source
Map only specific entities (IND, EUR, JAP)
Cost center* dimension begins with (03****)
Target
Map to target Cost center dimension -
- Add a prefix CC
- Members begins with 03**** in source should map to 04**** in target
Example
Source
Entity : IND, EUR, JAP
Cost Center : 03MCHJ, 03JIUY, 03KIJY
Target
Cost Center : CC04MCHJ, CC04JIUY, CC04KIJY
SOLUTION
In the Target value define #FORMAT("CC04##????")
No comments:
Post a Comment