You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Load Multi-Column Account dimension in Data Integration - Source Account doesn't map to Target

Summary:

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.

Content (required):

Below are a couple of screenshots to show the set up.

Map Dimensions

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!