Transformation Rule based on a different column in the source
Hi All, We're currently trying to map IC relationships in the transformation rules where the source data doesn't contain this field. We can map this based on the GL account from the ERP system but j...
Hey SamKing: yup, OneStream has you covered. This sounds like a standard Composite Transformation Rule.
Your rule expression will include both the target dimension (IC) as well as the dimension which can be used to identify the mapping (Account, in this instance) in the format of: A#UniqueAccount:I#*. Specify the I# target as the Target Value
This can be read as, 'anything from A#UniqueAccount from any I# should map to the I# Target Value'
Cheers,
-DB
