BOXI UserList & Group Extraction

Genius Team - any luck for SAP BO BI 4 . I would like to extract the user details with group like as following

Sub Group
Description and etc

Looking forward the macros…

stsrin :us: (BOB member since 2005-07-21)

Check if this utility for BO BI 4 can help you:

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

thank you for your kind reply - there i couldnt extract user, group details and etc …

stsrin :us: (BOB member since 2005-07-21)

Then I am not aware of any other such utility for BO BI 4.

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

Team - May I get the same kind of macro for SAP BO BI 4 - Looking forward to hear from you -

stsrin :us: (BOB member since 2005-07-21)

I get a compile error when I try this tool. error:
Compile error. Cannot find project or library. When I look at the code. It shows Dim SessionManager, Sess As SessionMgr


Ram31 (BOB member since 2004-11-29)

Thank you Ram - I am facing same error …

stsrin :us: (BOB member since 2005-07-21)

Hi Bo_Arale,

Could you please post the tool which is working for BO XI R3.


Chandru 901 :india: (BOB member since 2007-07-20)

Hello all BI4.x users,

I was able to extract BO Users and Groups lists using BI40 repository. Just FYI, we are currently on BI4.0 SP4, Patch 4.

I was trying to upload the new script for anyone who’s interested. But for some reason can’t do it with my profile. Let me know.

uploaded topic here:

Marek - can you grant me the privilege to upload the code?

Los Angeles, CA

Fernand_DaCien :us: (BOB member since 2006-05-06)


It’s done:

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


It’s very usefull and works very well with XI 3.1 SP3.

Thank you very much


b_gonzalez :fr: (BOB member since 2008-10-23)

Do we have anything useful for BO4?

dmitry.anoshin :ru: (BOB member since 2013-03-28)

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


I run BOXI UserList V3, and got “Compile error: Can’t find project library”

How can i fix it?

dmitry.anoshin :ru: (BOB member since 2013-03-28)

Hi Julien. Thank you very much for the Excel macro, it’s proven very useful for mass user loads.

I’m wondering if there is a way to automate the process of adding users (members) to groups in the BOXI3.1 CMC. Could this functionality be added to the macro, or is this better left for a separate macro/thread?

Also, is there any way to extend the timeout limit when either extracting from or modifying to the repository?

Michael Rodriguez

michael.rodriguez (BOB member since 2013-05-02)


I am getting the following error when using this utility.

Run-time error ‘-2147417848 (80010108)’:

Automation error
The object invoked has disconnected from its clients.

Please suggest.


sk_sadiq (BOB member since 2007-09-17)


Can this be used to get the user group list in BI 4.0 we have this new platform and I don’t see any Macro’s for this BI 4.0

bodiscussion (BOB member since 2010-07-11)


How can I make this utility work with Win AD authentication?
We have BO XIR3.1 SP4 with Win AD authentication?

When I try to connect with the utility, it is giving me connection error:
“Enterprise Authentication could not log you on. Please make sure your logon information is correct. (FWB 00008) 1000440.”

Any idea how to get it connected?

Thanks in advance.

izak004 :us: (BOB member since 2010-11-10)


The same answer as I replied to you other question:

Open the utilitie’s VBA code and replace every occurence of




That would be the easiest and fastest way.

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

Hi Marek,

Thank you for replying quickly.

Please excuse my ignorance for another doubt.

I have the ‘BOXI UserListV4’ version of the utility and when I open it, press ALT+F11, it opens VB for applications with one window with the following code

“Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If (Target.Row > 2 And Target.Column < 13) Then
Dim Rng As Excel.Range
Set Rng = Sheets(“Users”).Cells
For Each cell In Target
Rng(cell.Row, 13) = “1”
Next cell
End If
End Sub”

I looked into other options from the menu and on the right pane, but couldn’t understand where to change the code. Could you please guide me?

I was able to edit the code for the other utility but with error on some of the tabs, which I will ask/post later in that topic

Thanks again

izak004 :us: (BOB member since 2010-11-10)