BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

List of Usergroups and their Universe/ Universe Folders


 
Search this topic... | Search SDK (VBA/ASP/JSP)... | Search Box
Register or Login to Post    Forum Index -> SDK (VBA/ASP/JSP)  Previous TopicPrint TopicNext Topic
Author Message
msoniyam
Forum Member
Forum Member



Joined: 13 Apr 2018

Posts: 5



PostPosted: Fri Apr 13, 2018 4:43 am 
Post subject: List of Usergroups and their Universe/ Universe Folders

Hello,

Can anyone please help me to extract the list of usergroups and their respective universe folders in a particular environment.

My requirement is to extract Users and their respective Universe folders. I had divided the requirement into two parts. Users -> Usergroups and Usergroups -> Universe Folders.

I found and successfully completed by the first part. Please help me for the second part. Macro will be more helpful.

Please note that, I am using BI 4.1 SP5.

Thanks in Advance.
Soniya Mahaboob.
Back to top
Nick Daniels
Forum Aficionado
Forum Aficionado



Joined: 15 Aug 2002

Posts: 14141
Location: England


flag
PostPosted: Sat Apr 14, 2018 8:50 am 
Post subject: Re: List of Usergroups and their Universe/ Universe Folders

Welcome to Bicon_mrgreen.gifB!

I'll move this to the SDK forum for you. Good Luck icon_cool.gif
Back to top
msoniyam
Forum Member
Forum Member



Joined: 13 Apr 2018

Posts: 5



PostPosted: Wed Apr 18, 2018 7:34 am 
Post subject: Re: List of Usergroups and their Universe/ Universe Folders

Thanks Nick.

Can someone help me here? Thanks.

Soniya Mahaboob.
Back to top
ABILtd
Forum Enthusiast
Forum Enthusiast



Joined: 08 Feb 2006
ASUG Icon
Posts: 1820


flag
PostPosted: Thu Apr 19, 2018 6:58 am 
Post subject: Re: List of Usergroups and their Universe/ Universe Folders

Do some research on the Rest Web API, you can get all this kind of information using that.
_________________
BI and Analytics Presales Consultant
------------------------------------------------------
BOXI R1, R2, R3, R3.1, R4.1, R4.2, CE 8, 8.5, 9, 10, SAP Analytics Cloud, Crystal Reports, Lumira, PowerBI, Tableau, JasperServer, iReport, LogiAnalytics, BIRST, Qlikview, Xcelcius, Netezza, T-SQL, PLSQL, DTS, SSIS, BODI, BODS, Kimble etc....
------------------------------------------------------
Back to top
Hayden_Gill
Forum Associate
Forum Associate



Joined: 15 Aug 2002

Posts: 608
Location: Brisbane, Australia


flag
PostPosted: Fri Apr 20, 2018 12:28 am 
Post subject: Re: List of Usergroups and their Universe/ Universe Folders

There is no inherit relationship between usergroups and universe folders.

You may be adding multiple usergroups to the 'User Security' list for each universe folder - so that is the way you would need to tackle it i.e. for each folder, list the members of the 'User Security' list.

The other way (probably easier as you seem to already be able to list the members of a usergroup) is to create a usergroup for each universe folder.

Example: you have universe folders, UnvFolderA & UnvFolderB

Create two usergroups, UnvFolderA_Users & UnvFolderB_Users

Then
- add UnvFolderA_Users into the 'User Security' list for UnvFolderA and assign security
- add UnvFolderB_Users into the 'User Security' list for UnvFolderB and assign security

You then add users/usergroups as members of usergroups, UnvFolderA_Users & UnvFolderB_Users.

Then you can just list out the members of UnvFolderA_users when you need to know who has access to UnvFolderA.

_________________
Hayden Gill
Associate Director, BI
The University of Queensland
Brisbane, Australia
http://pbi.uq.edu.au
Back to top
msoniyam
Forum Member
Forum Member



Joined: 13 Apr 2018

Posts: 5



PostPosted: Mon Apr 23, 2018 2:54 am 
Post subject: Re: List of Usergroups and their Universe/ Universe Folders

Thanks. I will try and get back, if i got stuck somewhere.
Back to top
msoniyam
Forum Member
Forum Member



Joined: 13 Apr 2018

Posts: 5



PostPosted: Wed May 09, 2018 1:40 am 
Post subject: Re: List of Usergroups and their Universe/ Universe Folders

Hi,

I cant add the security to the user and usergroups at this stage as the whole environment is already set.

Can you please tell me the other way such that, i need list of all the universes in the environment and the users have access to the universe respectively?

Thanks,
Soniya Mahaboob.
Back to top
Hayden_Gill
Forum Associate
Forum Associate



Joined: 15 Aug 2002

Posts: 608
Location: Brisbane, Australia


flag
PostPosted: Wed May 09, 2018 1:46 am 
Post subject: Re: List of Usergroups and their Universe/ Universe Folders

No sorry, I have no idea how you have it setup... Lots of things complicate the issue, inheritance, people in multiple groups etc.

You'd be better off looking at some of the third party products that do this sort of thing...

_________________
Hayden Gill
Associate Director, BI
The University of Queensland
Brisbane, Australia
http://pbi.uq.edu.au
Back to top
hilfy
Forum Enthusiast
Forum Enthusiast



Joined: 16 Apr 2007
ASUG Icon
speaker.gif*3
Posts: 1855
Location: Atlanta, GA


flag
PostPosted: Wed May 09, 2018 10:58 am 
Post subject: Re: List of Usergroups and their Universe/ Universe Folders

Soniya, here's how to get this using the Java SDK:

1. Start from the universe folders - I usually get the SI_ID of the root universe folder and then query SELECT * FROM CI_SYSTEMOBJECTS AND SI_PARENTID = 563 AND SI_KIND = 'Folder' - this will get you all of the folders that are directly under the root (at the top level). If you have subfolders, you'll need to use recursion to walk down the folder tree to get the information.

2. For each folder, call .getSecurityInfo2() to get an ISecurityInfo2.

3. For the ISecurityInfo2, call .getExplicitPrincipals() to get the list of groups that have access to the folder. If there are any users explicitly assigned to the folder, they'll be in that list too.

4. If you just want the list of user groups that are explicitly assigned to the folder, you're done. If you want the list of groups that have inherited access to the folder, you'll need to repeat step 3 with .getEffectivePrincipals(). If you want to know what access they have, you'll need to use .getRoles() on the individual IExplicitPrincipal and/or IEffectivePrincipal object to get the SI_ID of the access level that has been used to assign access.

-Dell

_________________
Protiviti
Data & Analytics Practice
https://www.protiviti.com/US-en/data-management-advanced-analytics
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> SDK (VBA/ASP/JSP)  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0321 seconds using 18 queries. (SQL 0.0030 Parse 0.0009 Other 0.0282)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo