Universe Documentation Generator

system · March 23, 2007, 5:44pm

Author: TJ Abrahamsen, teab@edenenterprise.net
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:
UniverseDocumentor.dot: 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
universedocumentor.zip (27.0 KB)

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

system · March 26, 2007, 6:01pm

Approved, and moved to Bob’s Downloads.

Bobarella (BOB member since 2004-02-12)

system · July 25, 2007, 5:51pm

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

anybody else?

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

system · January 31, 2008, 12:50pm

Env.
Win XP
BO XI R2
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 (BOB member since 2005-12-20)

system · January 31, 2008, 12:55pm

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 (BOB member since 2002-08-15)

system · February 12, 2008, 5:12am

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)

system · February 20, 2008, 5:55pm

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

kmspsu93 (BOB member since 2006-04-06)

system · March 3, 2008, 4:26am

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 (BOB member since 2007-07-10)

system · April 3, 2008, 3:51pm

Can anyone get this to work?

DaveMC (BOB member since 2002-08-20)

system · May 9, 2008, 2:37pm

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)

system · May 15, 2008, 7:05am

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

Regards,
Santhosh

maverickee (BOB member since 2008-01-31)

system · May 16, 2008, 5:41pm

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 (BOB member since 2005-01-04)

system · May 28, 2008, 7:07pm

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!..

[i]
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)

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

ErrorHandler:
'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)

system · July 17, 2008, 7:20pm

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

thanks
Praveen

k_praveenvarma (BOB member since 2006-08-04)

system · September 4, 2008, 6:02am

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.

~Harish

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

system · September 5, 2008, 7:21pm

Hi

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.

Thanks

gmoorthyp (BOB member since 2005-08-29)

system · September 11, 2008, 7:46am

Hi,
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

Dreamz (BOB member since 2008-09-11)

system · September 11, 2008, 7:57am

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 (BOB member since 2002-06-06)

system · October 18, 2010, 5:30pm

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.

Karla

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)

system · December 2, 2010, 6:46am

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 (BOB member since 2008-05-21)