Need query builder queries

[Former Member]

Hello,

I need the below queries to be executed from query Builder

• Business Objects User and Group Association: Which user belongs to which group
• User Group and Folder Association: Security of a user group and different folders
• User Group and Universe Association: Security of user group on Universes

Thanks for your help in advance

Regards,

Laxminarayana

[former_member182521 · Accepted solution]

Hi Laxmi,

For

• Business Objects User and Group Association: Which user belongs to which group

          refer here http://scn.sap.com/thread/3295709

• User Group and Folder Association: Security of a user group and different folders

          select SI_ID,SI_NAME,SI_ADM_PRINCIPAL_RIGHTS from ci_infoobjects where           si_kind='Folder'  and SI_ANCESTOR=23

     This list all the folders and its child folders along with their rights on them for each User role

Regrds,

Mani

[Former Member · Accepted solution]

Thanks Mani, I am looking for something more here.. List of users in one column and their group name in the next column..

I have already checked that query:)

-Laxmi

[former_member182521 · Accepted solution]

SDK is the solution here. Kindly refer the COM SDK sample shared by Rahul which exactly suit your requirement.

[former_member202789 · Accepted solution]

Hi Laxmi,

Check out this doc: http://scn.sap.com/docs/DOC-35404

I had used this script a long time back and it worked for me. Check if meets your requirement.

Regards

Animesh

[former_member249128]

Hi Laxminarayana,

You can use the below query in Query Builder to find out the members of a group-

1. Use the below query to know the SID for the groups

  select si_id, si_name from ci_systemobjects where si_kind = 'Usergroup'

   2. Use the below query to get the list of users which are the member of the related group

  select si_name from ci_infoobjects,ci_appobjects,ci_systemobjects where(Descendants("si_relation_children_members_property='si_ent_group_members' or si_relation_children_groups_property='si_ent_group_members'", "si_id IN(1)")and not si_parentid in(49))

For the other two requirements, you can use Security Queries in CMC (CMC > Query Results > Security Query)

Regards,

Rahul

[Former Member]

Thanks for your reply Rahul, I have tried all the above options, but I need a query which can get me the list of all users and their groups in single table( I will put that in Excel). Also for the other two requirements I am looking for a query so that I can refresh it on a daily basis. can I export the security query results to Excel. I see an option in the Query tool, but its always grayed out though I am an administrator user.

-Laxmi

[former_member249128]

Hi Laxmi,

This is not quite possible to fetch all the users and their group membership from Query Builder. You'll have to create your custom code for that.

You can try this macro for that - http://www.forumtopics.com/busobj/viewtopic.php?t=89434

For your ability to export the security query results, I believe it has something to do with licensing. I'll check and that and let you know.

Regards,

Rahul

[Former Member]

Thanks Rahul,

I have downloaded the tool for BI 4.0 and trying to tweak in the code.

-Laxmi

[former_member222293]

Hi,

I am new to the world of SDK. I need to write JAVA code to display users associated with a particular group. I have the query builder query with me to get this information. But I am planning to write SDK so that I can build a form and extract the outcome in excel. Can anyone tell me how to get started with SDK?

[DellSC]

For general SDK information, you should look at the space.  On the home page there are links to a bunch of sample code.  That also is where you would ask questions about the SDK.

-Dell