BusinessObjects Board

Universe Documentation Generator

Author: TJ Abrahamsen,
Author notes: User guide is in attached zip file
Discussion: n/a
Platform: Windows XP, Word 2003, Business Object XI
Version: 0.1 (initial version)
Code: Code exists as Word VBA inside the Word template.

What this is:
This is a tool in the shape of a Word document template that helps you out when you want to document your universes. You select a .unv file and log on to Universe Designer. The result is a Word document with a title page, table of contents page, and page(s) with all the classes and objects from your universe file shown in the same outlined hierarchy as in the Universe Designer.

Attached ZIP file includes: The Word template to use from MS Word
Setup.doc: A short users guide

NOTE (disclaimer):
I have had the template tested successfully on two different computers using Word 2003, Windows XP, and Business Objects XI. I can not guarantee that it works on other versions.
Also, the template was created to ease my own work day, and to save time. I make this available hoping that others will be able to save a lot of time using it too…

Have fun,
TJ Abrahamsen,
Data Warehouse Engineer (27.0 KB)

Terje Abrahamsen :us: (BOB member since 2007-02-07)

Approved, and moved to Bob’s Downloads.

Bobarella (BOB member since 2004-02-12)

I’m getting a compile error when opening the template
“Can’t find project or library”

anybody else?

Chris Pohl :us: (BOB member since 2002-06-18)

Win XP
Word 2003

When I try to use this template, I choose my Universe and am prompted to login to Designer but then receive an error “Project -5: Invalid procedure call or argument”

stick_slinger :uk: (BOB member since 2005-12-20)

You have to tinker with a bit for XI…I think the one of the procedures has changed its name or something like that or maybe it was that it now accepts a different set of parameters.

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

Hi I am unable to do it in 6.5. If i run the dot file i am getting the following error. “Compile error: can’t find project or library” help me out guys…

aashad (BOB member since 2007-06-22)

Anyone know how to resolve the “Project -5: Invalid procedure call or argument” error?

kmspsu93 :us: (BOB member since 2006-04-06)

Hi Terje Abrahamsen,

i followed your steps to add Universe Documentor templette ,can you elaborate your step of adding universe file.

and where to write VB macro code?

Thanks in advance

Alapana :india: (BOB member since 2007-07-10)

Can anyone get this to work? :crazy_face:

DaveMC :us: (BOB member since 2002-08-20)

Yes, it worked for me. I’m using Designer 11.5 (XI R2) and MS Word 2002 (10.6838.6839) SP3.

nghoffman (BOB member since 2007-01-10)

Hi Abrahamsen,

I am not able to use this in BO 5.1 I changed the object library to 5.1 in tools->reference in VB editor still getting a error at Sub DocumentUniverse()

Anyway is it possible to use this macro for BO 5.1?

Thanks in advance


maverickee (BOB member since 2008-01-31)

There’s a problem with the line ‘Call AppActivate(CurrentApp)’ in the DocumentUniverse() sub. Basically, the workaround is to close ALL Word documents you have open, and run the Documentor as a template (as described in the Setup doc). Worked like a charm after that.


csurguine :us: (BOB member since 2005-01-04)

The workaround for the error: “Project -5: Invalid procedure call or argument”
that i found was just to ERASE the line "Call AppActivate(CurrentApp)’ on the visual basic code.
good luck!..

Sub DocumentUniverse()

Dim DesApp As Designer.Application
Dim Univ As Designer.Universe
Dim CurrentApp As String

On Error GoTo ErrorHandler

CurrentApp = Application.Caption
System.Cursor = wdCursorWait

Application.DisplayAlerts = False

'start Designer and log in
Set DesApp = New Designer.Application
DesApp.Window.State = dsMinimized
DesApp.Visible = True
Application.StatusBar = "Logging in..."
Call DesApp.LogonDialog

'open a universe
Application.StatusBar = "Opening universe..."
Set Univ = DesApp.Universes.Open(fldFileName.Value)

DesApp.Visible = False

'restore Excel as active application
Call AppActivate(CurrentApp)  [b]<--- i deleted this line and recompile :)[/b]
Application.ScreenUpdating = True

Call ListClasses(Univ.Classes, 1, 0)

On Error Resume Next
Application.StatusBar = False
System.Cursor = wdCursorNormal
Set Univ = Nothing
Set DesApp = Nothing
Exit Sub

'Call AppActivate(CurrentApp)
MsgBox Err.Source & " - " & Err.Number & ": " & Err.Description, _
vbCritical, “Failure in DocumentUniverse()”
Resume CleanUp

End Sub[/i]

korrait (BOB member since 2008-05-28)

Great the code works with the change in code as suggested :+1:
ENV : BO XIR2, Microsoft Word 2003


k_praveenvarma (BOB member since 2006-08-04)

This works great.

Saving of a huge time and efforts.

Keep on coming up with such brilliant tools.

Members like TJ and Kalyan are assets to this fourm. :+1:


harish.malik :india: (BOB member since 2008-07-14)


I am getting an error like Compile error: can’t find project or library. I am unable to run this. I followed the steps eventhough I am not able to run this.


gmoorthyp (BOB member since 2005-08-29)

I just came across this thread. I’ve tried this but failed and it would be great if someone can tell me what i did wrong.

  • I have a server running BO XIr2 on WIN2003. I take a copy of the universe and put it on my desktop PC.
  • My PC has Word 2003 installed; When i open a new document using the template, i get this error:

“Cannot find project / library”

The function highlighted is: “Sub ListClasses(Clss As Designer.Classes, RowNum As Long, ParentLevel As Long)”

I’ve tried the fix (removing Call AppActivate(CurrentApp)) but it did not resolve the problem.

So i am guessing: i might need some BO components installed on my PC as well to get this working? If so what are they?

Thanks in advance :slight_smile:

Dreamz (BOB member since 2008-09-11)

You need to have the Designer application installed and working on your computer. It’s used (referenced) by the code in order to open the universe and extract the information.

Dave Rathbun :us: (BOB member since 2002-06-06)

I know this is old, but has anyone had any luck in getting past the last error shown above? I just switched to Business Objects XI 3.1 and now the Word Template is not working. Any help would be appreciated.


Here is the error I’m now getting
Compile Error: Can’t find project or library
It is referencing the -
Sub ListClasses(Clss as Designer.Classes, RowNum as Long, ParentLevel as Long)

The error then gives me the following information:
Missing: BusinessObjects Designer 11.5 Object Library

I somehow got to the Library editor and it allowed me to pick both Business Objects Designer 12 Object Libraries
and then commented out the Excel reference as noted above and it appears to be working.

kyoungdahl (BOB member since 2010-10-18)

This is really a good template. If this application can also document down all the formula, relationship, object type, ect, then will be perfect! 8)

ylai20 :malaysia: (BOB member since 2008-05-21)