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

LogonID
Group
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

Thanks
Ram


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.

Thanks,
CK


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?

-Fernand_DaCien
Los Angeles, CA


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

Hi,

It’s done:


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

Hi,

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

Thank you very much

Regards,
Ben


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)

Nick,

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?

Thanks,
Michael Rodriguez


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

Hi,

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.

Regards,
Sadiq.


sk_sadiq (BOB member since 2007-09-17)

Hi

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)

Hi,

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)

Hi,

The same answer as I replied to you other question:

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

secEnterprise

with

secWinAD

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)