SAP BusinessObjects: assignment of User - aliases (SAP BW and AD)

[qamile]

Hi there,

Our SAP BO users are imported users from SAP BW and AD users.SSO is configured and all works very well, up to user merge.This means:

They are the same users but unfortunately they are not merged.It is the same users only they differ in the spelling.
e.g.

SAP BW: MARTIN

AD: Martin
Instead of merging the alias, it creates two users and we have to do the assignment of aliases manually.

is there a way to solve the problem?

many thanks and greetings

Mile

[BasicTek]

I'm sorry I read this too quickly, and it looked like the accounts were different. Our product is not case sensitive so if the username is an exact match (case doesn't matter) it should map. However if you have certain patches on 4.2 SP5 or SP6 there is an issue addressed by SAP note 2694847 - WinAD and SAP users with same name are not mapped under single User account

-Tim

[qamile]

Hi Tim,

Yes we have SAP BO 4.2 SP6.

many thanks 🙂 !

Mile

[jeremy_ma_usa]

Yes, Tim, I am from SAP Services, we developed a tool for some Enterprise Customers to merge their Aliases base on LDAP\AD Search. The use case was a lot more complicated where MARTIN_lastname merge with martin_emp123 but we able to find the match by a common LDAP attribute. @Mile, base on your example MARTIN should match, but maybe because of its case sensitive, is it possible that you can find a AD/LDAP attribute with all upper case, if yes then the BOBJ platform should be able to match it out of box.

But if you do require a unique lookup method, the code base was developed for 4.0 and later 4.1 by paid customer engagement. There is no update this code for a few years. I don't think it will take too much for the update and I may consider posting it in github opensource later if enough people ask for it.

[jeremy_ma_usa]

One more comment on the username/ID match btw BW and AD system. Please review this wiki site if SAP system alias was a cause of a new user account. Tim just confirms that case should not be sensitive to cause the distinction so you should be fine.

https://wiki.scn.sap.com/wiki/display/BOBJ/How+to+map+SAP+users+and+LDAP+users+in+SBO+BI4.0+CMC

[VinodBhat]

Hello Jeremy,

Thanks, We have similar need to SAP user id with AD user id based on attribute like email or similar. Did SAP come up with any out of box solution or considered to put the code on github?

Best Regards,

Vinod

[BasicTek]

If the username are different in the 2 plugins there is no automated way to accomplish the task of merging the users, however this issue does come up often and there are consultants that offer tools that use SDK scripting to find other common attributes and merge the aliases that way. I'll see if I can get one to respond in this thread, or else at this point the answer is to seek consulting help.

-Tim

[qamile]

tim.ziemba MANY THANKS