Hi All,
In Dataflow, has anyone had success pulling both/all split users on an opportunity? The issue I'm having is that the Opportunity Split extract is pulling only SplitOwnerId (the first user listed on the Opportunity Split) and not all User Id's associated with the Opportunity Split. The Team Member extract is doing the same and augmenting to the User extract or any other Opportunity related extract is not solving for this.
Any guidance here would be much appreciated.
Thanks,
Jeff
Update. I was able to bring in all opportunity split users for each opportunity using the hierarchy, flatten, and multi value options as you noted.
The issue I'm having now is that dollar amount for each user is the total dollar amount on the opportunity and not their portion. I can't calculate their dollar amount since the only option for Split Percentage being brought in for each opportunity is 100%.
Any suggestions would be greatly appreciated.
