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: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Document a universe using Excel and the Designer SDK
23 members found this topic helpful
Goto page Previous  1, 2, 3, 4 ... 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: Mon Jun 16, 2008 8:13 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Mike Murray wrote:
Where can I find the description for the numeric values brought back in the cardinality and outerjoins columns?

It's also in the SDK documentation. Take a look at the object model diagram (OMD), because the "enumerations" are included on the high-level diagram pages.

_________________
Dwayne Hoffpauir
Image link


Last edited by Dwayne Hoffpauir on Mon Jun 16, 2008 8:39 am, edited 1 time in total
Back to top
Mike Murray
Principal Member
Principal Member



Joined: 23 Dec 2005

Posts: 472
Location: Des Moines Iowa


flag
PostPosted: Mon Jun 16, 2008 8:15 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

thanks found the values.
Once again it is a great tool!

_________________
Mike Murray
Back to top
rajesh_tns
Forum Member
Forum Member



Joined: 18 Jun 2008

Posts: 27



PostPosted: Fri Jun 20, 2008 6:57 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Hi all

After downloading and opening the excel sheet I double clicked on Document a Universe Button then it opened a page and i saw this


Private Sub DocumentUniverseButton_Click()

Call DocumentUniverse

End Sub


what is my next step? how do i go from here to document the universe
Back to top
Mike Murray
Principal Member
Principal Member



Joined: 23 Dec 2005

Posts: 472
Location: Des Moines Iowa


flag
PostPosted: Fri Jun 20, 2008 7:14 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Do you have designer installed on your machine? It requires it and normally when you press the button the log in for designer will appear
_________________
Mike Murray
Back to top
rajesh_tns
Forum Member
Forum Member



Joined: 18 Jun 2008

Posts: 27



PostPosted: Fri Jun 20, 2008 7:18 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

yes i have BOXI installed ... i .e i have designer installed... on my machine...

as soon as i click it its opening a vb page
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: Fri Jun 20, 2008 8:03 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

rajesh_tns wrote:
Hi all

After downloading and opening the excel sheet I double clicked on Document a Universe Button then it opened a page and i saw this


Private Sub DocumentUniverseButton_Click()

Call DocumentUniverse

End Sub


what is my next step? how do i go from here to document the universe

Open the workbook, then press Alt-F11 (opens the VB editor). Go to Tools, References, and look for a Business Objects Designer library to be selected. What does it say (what version, etc.)? Go to Debug, Compile VBA project. Any error messages?

_________________
Dwayne Hoffpauir
Image link
Back to top
viewlakes
Senior Member
Senior Member



Joined: 27 Jan 2004

Posts: 47
Location: Western Washington



PostPosted: Wed Jun 25, 2008 4:55 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

How do I obtain this Excel file? Does it work with XI R2?
Back to top
Anita Craig
Forum Groupie
Forum Groupie



Joined: 17 Jun 2002

Posts: 8541
Location: Palo Alto, California, U.S.A.


flag
PostPosted: Wed Jun 25, 2008 5:33 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

viewlakes wrote:
How do I obtain this Excel file? Does it work with XI R2?

Look at the start of this topic for both downloads and additional information. icon_wink.gif

_________________
Anita Craig Image link
Institutional Research & Decision Support
Stanford University Image link
____________________
Search is Your Friendô
Back to top
jason_west
Forum Member
Forum Member



Joined: 21 Jan 2008

Posts: 6


flag
PostPosted: Wed Jul 16, 2008 10:11 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

How can this code be modified to display the unique ID of an object?
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 Jul 16, 2008 11:19 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

jason_west wrote:
How can this code be modified to display the unique ID of an object?

There is a hidden property (cleverly) named .Id (Obj.Id) that you can add to the utility as another column.

_________________
Dwayne Hoffpauir
Image link
Back to top
jason_west
Forum Member
Forum Member



Joined: 21 Jan 2008

Posts: 6


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

Sweet! Thanks mann.
Back to top
eye_candy
Principal Member
Principal Member



Joined: 18 Mar 2005

Posts: 419


flag
PostPosted: Wed Jul 16, 2008 4:08 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

Thanks Dwayne! Works Great!! icon_biggrin.gif cookie.gif mrs_bob.gif
Back to top
mukul.jain
Senior Member
Senior Member



Joined: 25 Oct 2005

Posts: 51


flag
PostPosted: Mon Jul 21, 2008 9:23 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

Thanks for this great tool.
Is it possible to document Object Level and Row Level Restrictions also.
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: Mon Jul 21, 2008 10:13 am 
Post subject: Re: Document a universe using Excel and the Designer SDK

mukul.jain wrote:
Thanks for this great tool.
Is it possible to document Object Level and Row Level Restrictions also.

Yes, but not with this tool. Those restrictions are stored separately in the repository, not as part of the universe itself.

_________________
Dwayne Hoffpauir
Image link
Back to top
mukul.jain
Senior Member
Senior Member



Joined: 25 Oct 2005

Posts: 51


flag
PostPosted: Tue Jul 22, 2008 1:09 pm 
Post subject: Re: Document a universe using Excel and the Designer SDK

Can that be extracted using CI_SYSTEMOBJECTS or there is something else.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Page 3 of 22 All times are GMT - 5 Hours
Goto page Previous  1, 2, 3, 4 ... 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.0405 seconds using 17 queries. (SQL 0.0097 Parse 0.0011 Other 0.0298)
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