BPC NW Account based model data load using flat file

123 Views Last edit Oct 31, 2016 at 09:06 PM 2 rev

Hi,

Model - Account based

I have a file with multiple key figures spread across columns. I have tried to use MVAL function to map the key figures to respective Account dim members. However mapping validation fails in Transformation file. ACCOUNT=*MVAL(*COL(75)|*NEWCOL(TONSOLD)||*COL((84)|*NEWCOL(TOTNTSALE)) Is this a valid syntax for csv files?

Regards