UserID to territory mapping
I want to automate the authorization for some BW reports related to CRM. The authorization is based on territory nodes (a copy of the CRM hierarchy is in the BW). Therefore, I'm looking for a mapping between CRM userids and territory and then load it into an ODS.
Any ideas? Thanks in advance!
What about a generic data source based on a function module. There you select all users, loop over them and call my function module to get the territory. You have have a closer look at my function module, check which table is storing the information about the user-territory-link and create a generic datasource about this table.