custom application to manage BI User

[former_member721411]

Hello community ,

I'm an intern who just started with BO, I'm basically a web developer.
I'm looking to create a custom application in order to create and delete BO user for BI4.2 version.

Do you know where I can find examples (simple) for this? wWth RESTful services or SDK?

I've done some research on google, but I find some old examples with old versions.

Thanks in advance for the help.
Kohan

[Former Member]

Thank you for visiting SAP Community to get answers to your questions. Since you're new in asking questions here, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members. For example, you can outline what steps you took to find answers (and why they weren't helpful), share screenshots of what you've seen/done, make sure you've applied the appropriate tags, and use a more descriptive subject line. The more details you provide, the more likely it is that members will be able to assist you. You should also make sure you're using all the appropriate tags, so the right experts can find your question.

Should you wish, you can revise your question now by selecting Actions, then Edit.

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS . By personalizing your profile with a photo of you, you encourage readers to respond.

Best regards

Mariah

SAP Community moderator

[ayman_salem · Accepted solution]

To get the list of groups for a user, use cmsquery

http://<server>:6405/biprws//v1/cmsquery

in body:

<attrs xmlns="http://www.sap.com/rws/bip">
 <attr name="query" type="string">select si_id, si_name from ci_infoobjects, ci_appobjects, ci_systemobjects Where parents("si_name='UserGroup-User'", "si_name='<UserNameHere>'")</attr>
</attrs>

[former_member721411 · Accepted solution]

it works perfectly.

Thank you very much

[former_member721412]

Hello Kohan,

You can find a full example here

https://blogs.sap.com/2017/04/21/session-management-in-bi-platform-rest-sdk-rws/

[ayman_salem]

see "Business Intelligence Platform RESTful Web Service Developer Guide"

Users: https://help.sap.com/viewer/db6a17c0d1214fd6971de66ea0122378/4.2.8/en-US/5d75a39e198643d88349b0f16ea...

Groups: https://help.sap.com/viewer/db6a17c0d1214fd6971de66ea0122378/4.2.8/en-US/8c048fa130ef45238adcf34f5dc...

[former_member721411]

Helllo Ayman,

Thank you for your help.

One more quesiton : how can I get the list of groups for a user ? like with id user i can get the groups which he is a member

Thank you very much for your help

Kohan

[former_member721411]

Thank you very much for the help to both of you.
I still have a question how can I get the list of groups for a user ?
what I find:
GET http://<baseURL>/v1/userGroups/<usergroup_id>/users
what I want is the other direction, a bit like

GET http://<baseURL>/v1/user/<user_id>/userGroups

As we check groups for user on CMS

Thanks in advance for the help.
Kohan