BOXI Repository Documentor

system · October 16, 2009, 8:00am

I have created the attached spreadsheet for XI R3 which will retrieve information about the reports, Universes, connections and categories in the BOXI environment. It will also provide information as to which reports use a specific universe and which reports may be affected by a universe change too - as returned when querying via the query builder.

It should be ran under the administrator account for the best results, but also works for delegated administrators/users.

The first tab has a section on the supported types and usage guide. It also mentions some limitations so PLEASE READ this first.

Changing the reference to that of the version 11.x libraries should enable this to work for XI R2, the ones that need changing are:
[list]
Crystal Enterprise Framework Library 12.0
Crystal Enterprise Infostore Library 12.0
BusinessObjects Designer 12.0 Object Library
[/list]
If you need to change the Referenced Libraries this can be accomplished by opening the document, select Tools > Macros> Visual Basic and then Tools > References.

This utility should be ran on a workstation which has the full BO client installation as it requires access to Designer and also libraries provided by the install.

Note for Moderator, original version can be found here

IF YOU ARE AFTER A VERSION FOR SAP BI 4, PLEASE USE THE “SAP BI Repository Documentor” which can be found here .

Update: V8 with some bug fixes and enhancements can be found here (for both R2 & R3).

Updated V7 with some bug fixes and enhancements can be found here.
BOXI Repository Documentor.zip (248.0 KB)

Sushir Patel (BOB member since 2006-04-19)

system · October 21, 2009, 1:39pm

I personally get a Type Mismatch error when running the utility, but wanted to make the utility available, because it seems quite useful. Any discussion or debugging efforts can continue in this thread.

Dwayne Hoffpauir (BOB member since 2002-09-19)

system · October 27, 2009, 1:10pm

I get an error too.

“VBAProject - 13: Type mismatch 1000013”

Transformer (BOB member since 2009-05-22)

system · October 27, 2009, 3:20pm

Has anyone got this to work?

Dwayne / Tranformer, where abouts are you encountering this Mismatch?

What version of BO XI are you using it against?

Sushir Patel (BOB member since 2006-04-19)

system · October 27, 2009, 4:16pm

I’m on XIR3.1. I have all the client tools installed and the preferences in Visual Basic Editor are pointing to the correct libraries. I am not quite sure why it is not working but cannot extend much time to investigate why it is not working.

Transformer (BOB member since 2009-05-22)

system · October 28, 2009, 8:24pm

I have no interest in debugging someone else’s code. I took a risk by moving this into public view, even though I knew it wasn’t clean. I was hoping the author would be around to work through the issues. We’ll see.

Dwayne Hoffpauir (BOB member since 2002-09-19)

system · October 29, 2009, 8:11am

Dwayne, I’m more than willing to help out - but I do require more information!

As you can see this tool has a lot of underlying code behind it and a response of

or

are not informative enough for me to help you out.

Please can you supply BO version you are using, Excel version, and a more precise line in the code that this is occuring. Also are there any other Add Ins installed like Business Query?

Thanks

HRS

Sushir Patel (BOB member since 2006-04-19)

system · October 29, 2009, 5:51pm

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

I have these checked in the refences(ones that pertain to BO):
[list]BusinessObjects Designer 12.0 Object Library
Crystal Enterprise Framework Library 12.0
Crystal Enterprise InfoStore Library 12.0
Crystal Enterprise qaaws PlugIn 12.0[/list]

Seems to error during the Documents pull.

Excel 2007
BO XI 3.1

THIS LOOKS TO BE AN AWESOME SET OF CODE!!! [list][/list][list][/list]

ericksobj (BOB member since 2004-09-13)

system · October 30, 2009, 8:04am

ericksobj - This was developed against Excel 2003. Is it possible for you to run it on a version of Excel 2003? I do not have that available to me.

I also have not tested this in US Date forrmat, it was developed in a UK environment (both Workstation and Severs).

Thanks

HRS

Sushir Patel (BOB member since 2006-04-19)

system · October 30, 2009, 1:50pm

FYI

Works like a charm against XI R2, obviously when pointing it to the correct references.

Thanks

ericksobj (BOB member since 2004-09-13)

system · October 30, 2009, 2:07pm

ericksobj - thanks for the feedback!

Sushir Patel (BOB member since 2006-04-19)

system · November 2, 2009, 10:09pm

Trust me, I understand. I’ve used that line here many times myself. A screenshot of the error is attached, and the specific line is as follows:

Rng(RowNum, 11) = CDate(Mid(DocumentItem.SchedulingInfo.BeginDate, 1, 10))

.BeginDate had a value of “8/8/2007 8:49:10 AM” at the time. That mid() function would return a value of “8/8/2007 8” … obviously can’t be coaxed into a valid date, so I suspect that is the problem.
Repository Documentor error.JPG

Dwayne Hoffpauir (BOB member since 2002-09-19)

system · November 3, 2009, 1:54pm

HRS… Do I know you perhaps?

If you are and this is the same spreadsheet you sent to me, it works a dream (after changing the libs for XIR2).
Extremely useful!

Cheers, Sandi

SandiR (BOB member since 2004-12-20)

system · November 8, 2009, 4:00pm

I have amended the utility so it now fixes the error outlined by Dwayne, and also now displays the corrects categories and universe Revision.

Please can you replace the version in the Downloads area with this one.

HRS
BOXI Repository Documentor.zip (246.0 KB)

Sushir Patel (BOB member since 2006-04-19)

system · November 20, 2009, 10:33am

Hi HRS

Perhaps you should submit your latest version now - the changes you did for linked and kernel universes are spot on!

Cheers,
Sandi

SandiR (BOB member since 2004-12-20)

system · December 3, 2009, 4:26pm

I’ve download this utililty and I’m getting an error when I run it. I get a ‘User-defined type not defined’. The progress windows shows that both the documents and universes have been processed and it is processing connections when this happens. When the error pops, it take me to the DocumentConnections subroutine and has the line of code ‘Dim Conn As Designer.Connection’ highlighted.

I am using Excel 2002 and BOXIR2. Any ideas what might be the issue?

BTW, this tool looks great. It will make life a lot easier.

Jim L

jlapham (BOB member since 2006-02-06)

system · December 3, 2009, 5:10pm

Have you changed the references over to release 11.5 from 12?

SandiR (BOB member since 2004-12-20)

system · December 3, 2009, 5:35pm

Yes I did. It would not even log in without doing this.

Jim

jlapham (BOB member since 2006-02-06)

system · December 4, 2009, 7:53am

Has the workstation got designer installed on it? This utility requires Designer to document the Connections.

If you do not have designer installed then uncheck the connections checkbox on the selection page and give that a whirl.

Also if you have miltiple BO environments, ensure the last repair / install is that of the XI version.

Sushir Patel (BOB member since 2006-04-19)

system · January 7, 2010, 10:32am

Great tool, HRS, thanks a lot of for making it and sharing it with us.

nnoori (BOB member since 2009-11-16)