Skip to Content
May 08, 2018 at 07:52 PM

How to load data from a flat file where 1 row contains multiple accounts and multiple entities


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