BusinessObjects Board

BOXI UserList & Group Extraction

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)

Where did you get the version 4 of the utility? I can’t find it now. :?


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

The link to V4 is in the first post of this topic,

I tried with V3, and I have the same problem, not able to understand where to edit it :roll_eyes:


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

Close that window (not the whole VBA editor). Then in the left panel you should see “Forms” folder. Open it and then right click on the fLogin form and select view code. This is the code where you need to replace secEnterprise with secWinAD.


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

I think somethings wrong with passing the credentials to WinAD.

I logged in with my credentials, the utility tried to validate it and errors out.

"Active Directory Authentication failed to get Active Directory groups for the account with the ID CN:AMA455, OU=USERS, OU=Mis, OU=Accounts " etc.

AMA455 is not my ID and I checked in our users, it seems to be an invalid user. There was a user with this ID and shes not with us anymore.
Wondering why it is trying to authenticate her when I’m providing my credentials.

Same error with V3 and V4 as well :hb:

Any idea?


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