I used MVAL function in the transformation file to map the amounts to various members in the account dimension however, in a given row, the amounts also map to different entities depending upon a combination of 2 to 4 fields in the flat file.
I tried using MVAL for the entity dimension as well however only 1 MVAL function is allowed in the transformation file. Any suggestions as to how to handle this?
BPC 10.1 NW