Document a universe using Excel and the Designer SDK

Dwayne Hoffpauir

Author: Dwayne Hoffpauir, EDS

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:

Kaustubh_1234 · Forum Member Joined: 25 Mar 2008 Posts: 7

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.

Dwayne Hoffpauir

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.

Kaustubh_1234 · Forum Member Joined: 25 Mar 2008 Posts: 7

Hi Dwayne,

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

BO_Chief

Kaustubh:

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

brawnbrawn · Senior Member Joined: 05 Mar 2008 Posts: 44

And I get the error:

"Compile error: Can't find project or Library"
with this part of code highlighted:

BO_Chief

brawnbrawn · Senior Member Joined: 05 Mar 2008 Posts: 44

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

Chris_K

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.

manishdarak · Forum Member Joined: 29 Mar 2006 Posts: 1

Hi Dwayne,

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

Thanks.
Manish

Dwayne Hoffpauir

Ramprasad · Forum Member Joined: 25 Jan 2008 Posts: 11

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 ?

Dwayne Hoffpauir

shruthi · Senior Member Joined: 25 Feb 2008 Posts: 70

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

Dave Rathbun

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.