As you might know, in SD one can have 4 Sales Rep for the same document (i.e. Sales Order). All of them goes to different fields in the extractors and from there, up to the DSO/Cubes.
How can I model them if I have to write a query of Sales by Sales Rep.
- Is there a kind of "Meta Sales Rep" to mean everyone of them?
- Should I take the four of them?
- How can have a report like this:
Sales Rep - Sales Net Value, - Qty,....etc.
Anyone have reported Sales Rep on SD who can bring some light?
Regards,