BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: Upcoming Events: BOBJ conference in Paris: Mar 28, PGHBOUG: Apr 4.

Document a universe using Excel and the Designer SDK
23 members found this topic helpful
Goto page 1, 2, 3 ... 20, 21, 22  Next
 
Search this topic... | Search BOB's Downloads... | Search Box
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Author Message
Dwayne Hoffpauir
Forum Groupie
Forum Groupie



Joined: 19 Sep 2002
ASUG Icon
medal_gold.gif*2speaker.gif*5medal_bronze.gif
Posts: 8644
Location: Plano, TX USA


flag
PostPosted: 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]



Document a Universe (XIr2).xls
 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:  32724 Time(s)


Document a Universe (v6.5).xls
 Description:
Version 6.5

Download
 Filename:  Document a Universe (v6.5).xls
 Filesize:  104 KB
 Downloaded:  8377 Time(s)


Document a Universe (v5.1).xls
 Description:
Version 5.1

Download
 Filename:  Document a Universe (v5.1).xls
 Filesize:  104 KB
 Downloaded:  5095 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
Forum Member



Joined: 25 Mar 2008

Posts: 11



PostPosted: 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
Forum Groupie



Joined: 19 Sep 2002
ASUG Icon
medal_gold.gif*2speaker.gif*5medal_bronze.gif
Posts: 8644
Location: Plano, TX USA


flag
PostPosted: 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
Forum Member



Joined: 25 Mar 2008

Posts: 11



PostPosted: 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
Forum Fanatic



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


flag
PostPosted: 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
Senior Member



Joined: 05 Mar 2008

Posts: 59



PostPosted: 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
Forum Fanatic



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


flag
PostPosted: 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
Senior Member



Joined: 05 Mar 2008

Posts: 59



PostPosted: 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
Senior Member



Joined: 10 Jan 2003

Posts: 79
Location: Cleveland, OH


flag
PostPosted: 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
Forum Member



Joined: 29 Mar 2006

Posts: 2



PostPosted: 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
Forum Groupie



Joined: 19 Sep 2002
ASUG Icon
medal_gold.gif*2speaker.gif*5medal_bronze.gif
Posts: 8644
Location: Plano, TX USA


flag
PostPosted: Tue Apr 22, 2008 8:30 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

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

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.
Back to top
Ramprasad
Forum Member
Forum Member



Joined: 25 Jan 2008

Posts: 11



PostPosted: 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
Forum Groupie



Joined: 19 Sep 2002
ASUG Icon
medal_gold.gif*2speaker.gif*5medal_bronze.gif
Posts: 8644
Location: Plano, TX USA


flag
PostPosted: 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
Principal Member



Joined: 25 Feb 2008

Posts: 108



PostPosted: 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
Forum Advocate



Joined: 06 Jun 2002

speaker.gif*16
Posts: 22124
Location: Dallas, Texas


flag
PostPosted: Wed Apr 23, 2008 12:23 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

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. icon_smile.gif
_________________
Dave's Adventures in Business Intelligence Image link

Latest Blog Posts
• 2019-02-11 Update on Query Banding
• 2018-10-19 BI Evolution
• 2018-09-13 Copying Content Is Not A Complement
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Page 1 of 22 All times are GMT - 5 Hours
Goto page 1, 2, 3 ... 20, 21, 22  Next
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0446 seconds using 19 queries. (SQL 0.0101 Parse 0.0026 Other 0.0319)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo