Document a universe using Excel and the Designer SDK

downloads
1

Author: Dwayne Hoffpauir, EDS Corporation

Notes: The attached utility uses Excel and the Designer SDK to document a universe. Usage is rather straightforward. Click the “Document a Universe” button on the Control Sheet, log in, and select the specific universe. Information will be recorded on separate worksheets for:[list]Database tables
Database columns
Joins
Contexts
Classes
Objects
Conditions[/list]

[Moderator Edit: Added BI4 Download Link in this post - Dave Rathbun]
Document a Universe (XIr2).xls (95.0 KB)
Document a Universe (v6.5).xls (106.0 KB)
Document a Universe (v5.1).xls (106.0 KB)

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

2

Hi Dwayne Hoffpauir,

Thanks for the spreadsheet.
When I try to execute the attached spreadsheet, I am getting the error
"Run-Time Error ‘91’ "
Cannot Get Mother CLass

Is there any remedy for the same.

Kaustubh_1234 (BOB member since 2008-03-25)

3

Hmmm … that error happens when trying to find the .Rootclass property for a class that is already at the top level. The code is supposed to trap that error and be able to continue. Any chance that you’ve tweaked the code, and possibly disabled the error handling? Does it happen if you download a clean copy? Be sure you are using the correct version of the utility as well. If that doesn’t fix it, I may have to ask you to send me a copy of the universe causing the problem.

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

4

Hi Dwayne,

I have downloaded a clean copy and try to execute the same.
I am still having the same issue.

Kaustubh_1234 (BOB member since 2008-03-25)

5

Kaustubh:

Are you using the correct Library of BO version. (I mean in the Tools–>Reference) ?

BO_Chief :us: (BOB member since 2004-06-06)

6

And I get the error:

“Compile error: Can’t find project or Library”
with this part of code highlighted:

Sub ListTables(Tbls As Designer.Tables)

Any Ideas please:

Thanks,
brawn

brawnbrawn (BOB member since 2008-03-05)

7

Do you see this function ‘ListTables’ exists in the code… when you go down in script window ?

BO_Chief :us: (BOB member since 2004-06-06)

8

Yes, I saw that sub() has been used couple of times in Dwayne’s code.
I get this error when i try to run all the version(Xir2, 6.5 and 5). . Is anything wrong on my PC? or is it for everybody.Any ideas dwayne

Thanks,
Brawn

brawnbrawn (BOB member since 2008-03-05)

9

Try going into the vba editor of Excel, then under ‘tools…references’ ,make sure you have checked ‘Business Objects Designer Library’. Then try running it. I hope this helps.

Chris_K :us: (BOB member since 2003-01-10)

10

Hi Dwayne,

Do you also have a similar macro which can be used to document a report.

Thanks.
Manish

manishdarak (BOB member since 2006-03-29)

11

For universe objects, try this … List objects used in a series of reports
To document more about a report, look here … http://lyontechnologies.com/free_stuff.htm … for the documentation add-in.

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

12

Hi,

When i tried to Document a universe.

i am getting the following error

Failure in ListObjects()

VBAProject- -2147417851: Automation error
The server threw an exception.

universe version : XIR2

Can any one please help me in this ?

Ramprasad (BOB member since 2008-01-25)

13

Any chance that the description on an object is extremely long … like more than 1,024 characters?
Try changing the line of code that says this…

Rng(RowNum, 4) = Obj.Description

… to this

Rng(RowNum, 4) = Left(Obj.Description, 1024)

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

14

what do the following mean in the documenting excel in Objects tab:
Security Access Level(0)/Can be used Result(True/False)/Can be used Condition(True/False)/Can be used sort(True/False)/Show(True/False)

Thanks
Shruti

shruthi (BOB member since 2008-02-25)

15

All of those are various properties of the object as set up in the universe. If you open a universe and look at the properties tabs (there are several) you should be able to figure it out. :slight_smile:

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

16

Hi Dwayne Hoffpauir,

Thanks for your reply.

I changed the Macro code,still i am getting the same error.

Thanks,
Ram

Ramprasad (BOB member since 2008-01-25)

17

I can only suggest that you step through the code, and report back exactly which object, property, and value is causing the problem. I may be able to offer a solution with that information.

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

18

Dwayne,
I used the download for 6.5 and it worked great for the first universe I tried. But when I run it against a much larger universe, it gives me a "Failure in ListObjects(): “VBAProject 7 - out of memory” error. Do you know of a way to get around this? Does it mean physical memory on my PC (it is rather old).
Thank you so much, Linda

lindacaron :us: (BOB member since 2002-07-16)

19

Hi

I get the error:

“Compile error: Can’t find project or Library”
with this part of code highlighted:

For this how can i include the business objects library ?

Adv. Thanks
Raghu

rpothineni :india: (BOB member since 2008-01-02)

20

Might the discussion here explain it?

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