Load Multi-Column Account dimension in Data Integration - Source Account doesn't map to Target
Hi, I'm trying to do a file load to a Planning cube. My file has multiple account members in the column. I have watched all the videos and reviewed the guide but when I run the integration, the Source Account is correct (the correct member names) but the Target Account is picking up the data value for the first account member for all account members. The data values are correct though.
Below are a couple of screenshots to show the set up.
Account starts in column 13-20. All previous columns are other required dimensions. I have the Value (amount column) defined as a Driver=Account, List of Members, 13,20