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

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (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: 3



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: 14009
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: 3



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: 1800


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, 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: 595
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: 3



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
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.0114 seconds using 18 queries. (SQL 0.0032 Parse 0.0002 Other 0.0080)
CCBot/2.0 (http://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