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: Upcoming Events: SAP TechEd: Sep 28.

BI40 Users and Groups Lists

Goto page 1, 2, 3  Next
 
Search this topic... | Search BOB's Downloads... | Search Box
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Author Message
Fernand_DaCien
Senior Member
Senior Member



Joined: 05 May 2006

Posts: 34
Location: Los Angeles, California


flag
PostPosted: Mon Jan 14, 2013 7:00 pm 
Post subject: BI40 Users and Groups Lists

Hello All,

Here's an update to the BO Users list script, which was developed originally by Julien Bras, 01/2008. To view the original link, click topic below:
http://www.forumtopics.com/busobj/viewtopic.php?t=89434

The latest file contains references to the BI4.0 assemblies.
If you haven't installed the BI4.x client, the script will fail. So, make sure to install the BI40 Platform Client tool first before executing the script.

Moderators please review the uploaded file for everyone to use: <BOBI4_UserList_V001.zip>


Also, thanks to Julien for the original code.

Enjoy!
Fernand_DaCien
(UTC)



BOBI4_UserList_V001.zip
 Description:
BI40 Users and Groups List version 001.

Download
 Filename:  BOBI4_UserList_V001.zip
 Filesize:  34.11 KB
 Downloaded:  5416 Time(s)

Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19056
Location: Bratislava


flag
PostPosted: Mon Jan 14, 2013 10:35 pm 
Post subject: Re: BI40 Users and Groups Lists

Moderator note:
Approved, and moved to BOB's Downloads.


Thanks for sharing.

_________________
BO: BI 4.0, 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win, Linux and AIX servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
stsrin
Principal Member
Principal Member



Joined: 20 Jul 2005

Posts: 138
Location: USA


flag
PostPosted: Wed Feb 06, 2013 3:49 am 
Post subject: Re: BI40 Users and Groups Lists

hello - which is not working - follwed steps too
Back to top
Fernand_DaCien
Senior Member
Senior Member



Joined: 05 May 2006

Posts: 34
Location: Los Angeles, California


flag
PostPosted: Wed Feb 06, 2013 12:43 pm 
Post subject: Re: BI40 Users and Groups Lists

Hi,

I'm not sure if you're making a statement or asking a question.


-Fernand
Back to top
stsrin
Principal Member
Principal Member



Joined: 20 Jul 2005

Posts: 138
Location: USA


flag
PostPosted: Tue Feb 12, 2013 3:36 am 
Post subject: Re: BI40 Users and Groups Lists

Fernand - steps followed as per instruction - unable to extract the userlist . Sorry for the late response.
Back to top
Fernand_DaCien
Senior Member
Senior Member



Joined: 05 May 2006

Posts: 34
Location: Los Angeles, California


flag
PostPosted: Tue Feb 12, 2013 12:20 pm 
Post subject: Re: BI40 Users and Groups Lists

strsin,

Can you let me know which step is not working? e.g. eSession, Authentication, invalid reference, etc...?
Or are you getting an error when you execute the script?
Also, which version of BI4 client is installed on the machine?

If possible, take a screen print and post it here. Not knowing which step is failing is not helpful.

-Fernand
Back to top
stsrin
Principal Member
Principal Member



Joined: 20 Jul 2005

Posts: 138
Location: USA


flag
PostPosted: Thu Feb 14, 2013 12:15 am 
Post subject: Re: BI40 Users and Groups Lists

Fernand - Thank you for your kind mail and consideration. I was not able to run the macro(Excel doesn't contain macros - I believe , correct me if I am wrong )

Mine is BI4 SP5 and looking forward to hear from you.

Thank you again - Srinivasan
Back to top
PRIME
Forum Member
Forum Member



Joined: 30 Aug 2011
ASUG Icon
Posts: 2



PostPosted: Thu Apr 04, 2013 12:16 pm 
Post subject: Re: BI40 Users and Groups Lists

Tried using this macro, no luck- received Run-time error:
"Automation Error-The object invoked has disconnected from its clients"

Enviroment- BI4.0 SP3, Office 2007, Windows7
Back to top
adadevil
Forum Member
Forum Member



Joined: 13 Jan 2010

Posts: 4



PostPosted: Fri Jul 26, 2013 3:01 pm 
Post subject: Re: BI40 Users and Groups Lists

I get the error on the "Set UserObject = UserItem" line. Says Run time error '13': Type Mismatch.

Any ideas on how to fix that?

thanks
Back to top
Sandhiri
Forum Member
Forum Member



Joined: 05 Aug 2013

Posts: 2



PostPosted: Mon Aug 05, 2013 10:26 pm 
Post subject: Re: BI40 Users and Groups Lists

Hi Fernand_DaCien...do you have a similar file for BOXIR3 SP3?
Back to top
BO JAC
Forum Member
Forum Member



Joined: 29 May 2013

Posts: 2



PostPosted: Wed Sep 04, 2013 5:07 pm 
Post subject: Re: BI40 Users and Groups Lists

Hi. seeya.gif

i need to know which reports are assigned to which users.

Can you help me?

icon_neutral.gif
Back to top
surgeon648
Forum Member
Forum Member



Joined: 31 Jul 2009

Posts: 12
Location: San Antonio, TX


flag
PostPosted: Fri Jan 10, 2014 9:37 am 
Post subject: Re: BI40 Users and Groups Lists

Fernand,

My company changed to Outlook 2010 and now the script will not run. We are getting a popup error stating 'Compile error: User-defined type not defined'.

We are using BI4 SP7.1. I have removed all references related to 12 and added 14 for Crystal Enterprise and BusinessObjects Enterprise.

Could you tell me what reference the users are included in?
Back to top
surgeon648
Forum Member
Forum Member



Joined: 31 Jul 2009

Posts: 12
Location: San Antonio, TX


flag
PostPosted: Fri Jan 10, 2014 10:41 am 
Post subject: Re: BI40 Users and Groups Lists

Update:
I found the User and User Group .dll files in Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86 but when I try to add them, the Crystal Enterprise User PlugIn 12 and Crystal Enterprise UserGroup Plugin 12 become checked.

When trying to run using these, I get an error stating 'could not connect to the server. Please check that the server name is correct, and that the server is running. 1000440'
Back to top
Lynnieshell
Forum Member
Forum Member



Joined: 18 Sep 2012

Posts: 20


flag
PostPosted: Thu Feb 05, 2015 7:43 am 
Post subject: Re: BI40 Users and Groups Lists

Just found this and it's great. Trying to manage 15k + users is no mean feat icon_eek.gif
Have been using the prev version but good to find an updated one for BO4.

Just wanted to say thanks for sharing icon_biggrin.gif
Back to top
passport
Senior Member
Senior Member



Joined: 07 May 2010

Posts: 87



PostPosted: Fri Feb 13, 2015 5:23 pm 
Post subject: Re: BI40 Users and Groups Lists

I get the following error when i try to run the macro, please let me know how to fix it. Thanks

Run-time error '-2147417848 (80010108)':

Automation error
The object invoked has disconnected from its clients.

Image link
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Page 1 of 3 All times are GMT - 5 Hours
Goto page 1, 2, 3  Next
 
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.0191 seconds using 21 queries. (SQL 0.0065 Parse 0.0026 Other 0.0099)
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