BusinessObjects Board

BI40 Users and Groups Lists

downloads
#21

Thanks Marek for your response. I tried it, but it is throwing an error -

Run-time Error 'some no…

Automation Error
The object invoked has disconnected from its clients

aniketp :uk: (BOB member since 2007-10-05)

#22

not working for me either… multiple errors.

sapaa (BOB member since 2014-02-21)

#23

Hi,

I am using Excel 2010 and I have all BI 4.1 client tools installed. The script retrieved userlist till 65536 and prompted error:
“Error 1004 “Application-defined or Object-defined error””
We have 90k+ users in BO and need information of all of them.

Please help.

Regards,
Lokesh

lokeshborse :india: (BOB member since 2010-09-21)

#24

Either get it to run in Excel 2007 or above…or tweak the code so it does your user base in two chunks.

Nick Daniels :uk: (BOB member since 2002-08-15)

#25

Thanks Nick. I don’t know how to use macros hence unable to twick the code. Could you please help to edit to run in 2 sheets? Because I have excel 2010 only.

Regards,
Lokesh

lokeshborse :india: (BOB member since 2010-09-21)

#26

Not me, I am afraid. Hopefully someone will give you some pointers…90,000 is a lot of users :wink:

Nick Daniels :uk: (BOB member since 2002-08-15)

#27

Yes Nick. We have lot of users but what to do… Its our Production environment. Hope someone will help to twick the code

lokeshborse :india: (BOB member since 2010-09-21)

#28

Hi,

The original utility is saved in the version Excel 97-2003 - it has a limit of 65536 rows. So I am guessing that even though you run it in Excel 2010, it still has this limit internally somehow applied.

So try saving the utility in the Excel 2010 format, as an MS Excel Macro-Enabled Worksheet and then try to run it again.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

#29

Thanks Marek. I saved the excel 2003 macro excel in Excel 2010 macro enabled format (.xlsm) and ensure macro enabled in settings - Enable all Macros(in Trust Center settings).

I am running the script again and let you know how it goes.

lokeshborse :india: (BOB member since 2010-09-21)

#30

Hi Marek,

It worked successfully. I was able to retrieve 96k users.

Thanks,
Lokesh

lokeshborse :india: (BOB member since 2010-09-21)

#31

Excellent :+1:

Marek Chladny :slovakia: (BOB member since 2003-11-27)

#32

I was using this happily but have been moved to excel 2013 and now I get an error

Compile Error: Can’t find Project or Library.

Any ideas what this means and how I fix it?

I’m lost without this little tool :nopity:

Lynnieshell :uk: (BOB member since 2012-09-18)

#33

Hi All,

I tried running the code but get error as my BO authentication type is Windows.

Can someone help me as what should be the authentication type string here

Set esession = SessionManager.Logon(tbName, tbPassword, tbCMS, “secEnterprise”)

What should be the value instead of SecEnterprise if my authentication type is Windows.

Thank you,
Arun

Arun8006 (BOB member since 2006-12-22)

#34

Hi,

Then try using secWinAD instead of secEnterprise.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

#35

Wow … That worked!

Thank you very much
Arun

Arun8006 (BOB member since 2006-12-22)

#36

Great utility!! We recently upgraded to 4.1 SP06 Patch 04

I had to update one of the references as the old one was missing… It was a Crystal reference but I didn’t write down the specific one…

Now I get the error:

Failure in UsersGroups()
VBAProject - -2147467259: Automation error
Unspecified error 1000440

Any ideas?

OmaCoder (BOB member since 2015-11-03)

#37

I am getting “Active directory authentication failed to get the active directory groups for the account with ID…” . I am not able to find the username to delete form the CMC so I am not able to progress it further. Any idea how can it move further?

anutosh.dhar (BOB member since 2014-01-30)

#38

Is there way to add the universe?
We have universe in a usergroup

so I can see which user has access to the universe

EmilBras (BOB member since 2011-12-09)

#39

Hello,

I am getting the following error when I try to run the User List macro:

CrystalEnterprise14.SessionMgr.1 --2147210751: Unable to log on: Could not connect to server xxx:6400. Please check that the server name is correct, and that the server is running. 1000440.

I am on BI 4.1 SP4 but I previously had it running fine on BI 3.0 and 4.0. Any suggestions on how to get this to

work are greatly appreciated.

Thanks.

Update 10/3/2016: I was able to get it working. Thanks!

GK1494 (BOB member since 2016-09-30)

#40

Hi

I’m getting error “VBAProject - 13: Type mismatch 1000013”.

Please help me to resolve this.

My Office version : Office 365 ProPlus (16.0.11328.20230) 64 bit

BO 4.2 SP5 P5

Your help much appreciated.

Warm Regards
Amar

amarnatha :india: (BOB member since 2006-05-08)