Author |
Message |
Dwayne Hoffpauir Forum Groupie


Joined: 19 Sep 2002
                 
*2 *5 Posts: 8644 Location: Plano, TX USA

|
Posted: Thu Mar 02, 2006 3:16 pm Post subject: Document a universe using Excel and the Designer SDK |
|
|
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:Database tables
Database columns
Joins
Contexts
Classes
Objects
Conditions
[Moderator Edit: Added BI4 Download Link in this post - Dave Rathbun]
Description: |
Version XIr2 - also works with XI 3.0 (in VB editor, go to Tools, References... and change to 12.0 library if needed). |
|
 Download |
Filename: |
Document a Universe (XIr2).xls |
Filesize: |
93.5 KB |
Downloaded: |
33219 Time(s) |
Description: |
|
 Download |
Filename: |
Document a Universe (v6.5).xls |
Filesize: |
104 KB |
Downloaded: |
8574 Time(s) |
Description: |
|
 Download |
Filename: |
Document a Universe (v5.1).xls |
Filesize: |
104 KB |
Downloaded: |
5221 Time(s) |
Last edited by Dwayne Hoffpauir on Thu Aug 21, 2008 11:04 am, edited 1 time in total |
|
Back to top |
|
 |
Kaustubh_1234 Forum Member


Joined: 25 Mar 2008
           Posts: 11

|
Posted: Tue Mar 25, 2008 8:18 am Post subject: Re: Document a universe using Excel and the Designer SDK |
|
|
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.
|
|
Back to top |
|
 |
Dwayne Hoffpauir Forum Groupie


Joined: 19 Sep 2002
                 
*2 *5 Posts: 8644 Location: Plano, TX USA

|
Posted: Tue Mar 25, 2008 9:30 am Post subject: Re: Document a universe using Excel and the Designer SDK |
|
|
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.
|
|
Back to top |
|
 |
Kaustubh_1234 Forum Member


Joined: 25 Mar 2008
           Posts: 11

|
Posted: Tue Mar 25, 2008 9:51 am Post subject: Re: Document a universe using Excel and the Designer SDK |
|
|
Hi Dwayne,
I have downloaded a clean copy and try to execute the same.
I am still having the same issue.
|
|
Back to top |
|
 |
BO_Chief Forum Fanatic


Joined: 06 Jun 2004
                Posts: 5585 Location: Somewhere on God's Land.

|
Posted: Tue Mar 25, 2008 11:21 am Post subject: Re: Document a universe using Excel and the Designer SDK |
|
|
Kaustubh:
Are you using the correct Library of BO version. (I mean in the Tools-->Reference) ?
_________________ help us help you! make sure your post has the following elements:
• Does it include BO version, Database, an error, a problem, a SQL for object or Condition ?
• Does it include some sample data what you have?
• Does it include any code you already tried ? (working or not..)
• Did you explain what you want for results?
If any of those elements are missing,chances are you didn't post enough information for us to help you! |
|
Back to top |
|
 |
brawnbrawn Senior Member


Joined: 05 Mar 2008
           Posts: 59

|
Posted: Wed Mar 26, 2008 2:02 pm Post subject: Re: Document a universe using Excel and the Designer SDK |
|
|
And I get the error:
"Compile error: Can't find project or Library"
with this part of code highlighted:
Code: | Sub ListTables(Tbls As Designer.Tables) |
Any Ideas please:
Thanks,
brawn
|
|
Back to top |
|
 |
BO_Chief Forum Fanatic


Joined: 06 Jun 2004
                Posts: 5585 Location: Somewhere on God's Land.

|
Posted: Wed Mar 26, 2008 2:56 pm Post subject: Re: Document a universe using Excel and the Designer SDK |
|
|
brawnbrawn wrote: | And I get the error:
"Compile error: Can't find project or Library"
with this part of code highlighted:
Code: | Sub ListTables(Tbls As Designer.Tables) |
Any Ideas please:
Thanks,
brawn |
Do you see this function 'ListTables' exists in the code.. when you go down in script window ?
_________________ help us help you! make sure your post has the following elements:
• Does it include BO version, Database, an error, a problem, a SQL for object or Condition ?
• Does it include some sample data what you have?
• Does it include any code you already tried ? (working or not..)
• Did you explain what you want for results?
If any of those elements are missing,chances are you didn't post enough information for us to help you! |
|
Back to top |
|
 |
brawnbrawn Senior Member


Joined: 05 Mar 2008
           Posts: 59

|
Posted: Wed Mar 26, 2008 4:08 pm Post subject: Re: Document a universe using Excel and the Designer SDK |
|
|
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
|
|
Back to top |
|
 |
Chris_K Senior Member


Joined: 10 Jan 2003
                Posts: 79 Location: Cleveland, OH

|
Posted: Mon Mar 31, 2008 10:27 am Post subject: Re: Document a universe using Excel and the Designer SDK |
|
|
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.
|
|
Back to top |
|
 |
manishdarak Forum Member


Joined: 29 Mar 2006
             Posts: 2

|
Posted: Tue Apr 22, 2008 6:22 am Post subject: Re: Document a universe using Excel and the Designer SDK |
|
|
Hi Dwayne,
Do you also have a similar macro which can be used to document a report.
Thanks.
Manish
|
|
Back to top |
|
 |
Dwayne Hoffpauir Forum Groupie


Joined: 19 Sep 2002
                 
*2 *5 Posts: 8644 Location: Plano, TX USA

|
|
Back to top |
|
 |
Ramprasad Forum Member


Joined: 25 Jan 2008
           Posts: 11

|
Posted: Wed Apr 23, 2008 1:08 am Post subject: Re: Document a universe using Excel and the Designer SDK |
|
|
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 ?
|
|
Back to top |
|
 |
Dwayne Hoffpauir Forum Groupie


Joined: 19 Sep 2002
                 
*2 *5 Posts: 8644 Location: Plano, TX USA

|
Posted: Wed Apr 23, 2008 8:00 am Post subject: Re: Document a universe using Excel and the Designer SDK |
|
|
Ramprasad wrote: | Failure in ListObjects()
VBAProject- -2147417851: Automation error
The server threw an exception. |
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... Code: | Rng(RowNum, 4) = Obj.Description |
... to this Code: | Rng(RowNum, 4) = Left(Obj.Description, 1024) |
|
|
Back to top |
|
 |
shruthi Principal Member


Joined: 25 Feb 2008
           Posts: 108

|
Posted: Wed Apr 23, 2008 12:15 pm Post subject: Re: Document a universe using Excel and the Designer SDK |
|
|
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
|
|
Back to top |
|
 |
Dave Rathbun Forum Advocate


Joined: 06 Jun 2002
                
*16 Posts: 22140 Location: Dallas, Texas

|
|
Back to top |
|
 |
|