BO User Groups based on Extended LDAP User Attributes

[Former Member]

Hello Experts 

I have configured LDAP with Business Objects. As a part of configuration I also imported additional/extended user attributes ( Country). Using SAP Note - 1880091.

I need to know how I can create Business Objects Users group based on extended attributes ( for example Country).

So i would have all country specific users in one group in business Objects.

Please help.

Thanks

R

[Former Member · Accepted solution]

You can use java application which throw java api will be incude users to their groups using additional LDAP attributes.

http://scn.sap.com/community/bi-platform/blog/2014/11/25/how-to-create-a-program-file-in-bi4

We use this method to map WinAD and SAP users using email value from AD and from SAP

[Former Member · Accepted solution]

Thanks for your response. Do you sample code you have used for E-mail Value.

Regards,

Ron

[Former Member · Accepted solution]

1.Create Custom User Attributes

2.

String query ="SELECT SI_ID,SI_EMAIL_ADDRESS,SI_CUSTOM_MAPPED_ATTRIBUTES  from CI_SYSTEMOBJECTS WHERE SI_PROGID='CrystalEnterprise.USER' and not SI_NAME in('Test','Administrator','SMAdmin','Guest','QaaWSServletPrincipal') ";

BOQueryResults = boInfoStore.query(query) ;

IUser myUser = (IUser) BOQueryResults.get(i);

String SAP_EMAIL = "";

try {

  IProperties prop1 = myUser.properties();

  IProperties prop2 = (IProperties)prop1.getProperties("SI_CUSTOM_MAPPED_ATTRIBUTES");

    }catch(java.lang.NullPointerException e){}

try {

  SAP_EMAIL = (prop2.getString("SI_SAP_EMAIL")).toUpperCase();

  if(SAP_EMAIL == null) SAP_EMAIL = "";

    }catch(java.lang.NullPointerException e){SAP_EMAIL = "";}

[Former Member · Accepted solution]

Perfect , Thank You.