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

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

Universe Documentor (Dwayne's plus a few extras)
1 members found this topic helpful
Goto page 1, 2, 3  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
SandiR
Principal Member
Principal Member



Joined: 20 Dec 2004
ASUG Icon
Posts: 273
Location: By the sea


flag
PostPosted: Tue Nov 03, 2009 9:45 am 
Post subject: Universe Documentor (Dwayne's plus a few extras)

Hi all

I have made a few updates to Dwayne's extremely useful Universe Documentor.

Documents derived table sql
Alias and physical table names for objects and conditions,
textual descriptions rather than coded values for many items.
Linked universe
Additional universe param info.
Conditional formatting to highlight hidden objects.

Cheers, Sandi



BOXI Universe Documentor v4.xls
 Description:
Set against XIR2

Download
 Filename:  BOXI Universe Documentor v4.xls
 Filesize:  155.5 KB
 Downloaded:  6798 Time(s)


_________________
Sandi

Available for contract work throughout the UK from 1st September 17
uk.linkedin.com/pub/sandi-rocca/1b/262/776/

BI4 - Windows/Tomcat/SQL Server 2008
XI 3.1 - Solaris/Netezza
XIR2, 6, 5.1.9 - Solaris/Weblogic/Oracle

WebI, CMC, Xcelcius/Dashboards4, BI Mobile, CR, BI Explorer, DeskI
Back to top
Dave Rathbun
Forum Advocate
Forum Advocate



Joined: 06 Jun 2002

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


flag
PostPosted: Tue Nov 03, 2009 10:13 am 
Post subject: Re: Universe Documentor (Dwayne's plus a few extras)

So do we start a new topic for this? Or merge it into Dwayne's topic? I haven't reviewed the code, just trying to think about how we manage this.
_________________
Dave's Adventures in Business Intelligence Image link

Latest Blog Posts
• 2019-09-19 Stephen Few Blog Post on Multivariate Visualization
• 2019-02-11 Update on Query Banding
• 2018-10-19 BI Evolution
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 Nov 03, 2009 11:10 am 
Post subject: Re: Universe Documentor (Dwayne's plus a few extras)

Might be a bit selfish, but I'd prefer a new topic. A couple of reasons. I have an idea that I'll update my version someday. Plus, I'd rather not have two separate "debugging" discussions mixed in one thread. Someone reports an error, and we have to ask "which version."
_________________
Dwayne Hoffpauir
Image link
Back to top
Dave Rathbun
Forum Advocate
Forum Advocate



Joined: 06 Jun 2002

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


flag
PostPosted: Tue Nov 03, 2009 11:15 am 
Post subject: Re: Universe Documentor (Dwayne's plus a few extras)

That's certainly valid and I appreciate your concern. My initial inclination was to keep them as separate topics as well.
_________________
Dave's Adventures in Business Intelligence Image link

Latest Blog Posts
• 2019-09-19 Stephen Few Blog Post on Multivariate Visualization
• 2019-02-11 Update on Query Banding
• 2018-10-19 BI Evolution
Back to top
SandiR
Principal Member
Principal Member



Joined: 20 Dec 2004
ASUG Icon
Posts: 273
Location: By the sea


flag
PostPosted: Tue Nov 03, 2009 11:41 am 
Post subject: Re: Universe Documentor (Dwayne's plus a few extras)

Dwayne Hoffpauir wrote:
Might be a bit selfish, but I'd prefer a new topic. A couple of reasons. I have an idea that I'll update my version someday. Plus, I'd rather not have two separate "debugging" discussions mixed in one thread. Someone reports an error, and we have to ask "which version."


Well Dwayne, you have got every right to be selfish - it's a brill utility.


I have tried to test it as much as I am able - the only exceptions I have received in the last tests have been as a result of errors in the universe which the integrity check didn't report.

Cheers, Sandi

_________________
Sandi

Available for contract work throughout the UK from 1st September 17
uk.linkedin.com/pub/sandi-rocca/1b/262/776/

BI4 - Windows/Tomcat/SQL Server 2008
XI 3.1 - Solaris/Netezza
XIR2, 6, 5.1.9 - Solaris/Weblogic/Oracle

WebI, CMC, Xcelcius/Dashboards4, BI Mobile, CR, BI Explorer, DeskI
Back to top
SandiR
Principal Member
Principal Member



Joined: 20 Dec 2004
ASUG Icon
Posts: 273
Location: By the sea


flag
PostPosted: Tue Nov 03, 2009 1:18 pm 
Post subject: Re: Universe Documentor (Dwayne's plus a few extras)

Dave/Dwayne

Can you hold off till tomorrow please?
One of my developers has said he received an error with the util.
This may be a universe error, but until I know for certain I would rather safe than sorry.
I am just awaiting screenshots of the error now.

Cheers, Sandi

_________________
Sandi

Available for contract work throughout the UK from 1st September 17
uk.linkedin.com/pub/sandi-rocca/1b/262/776/

BI4 - Windows/Tomcat/SQL Server 2008
XI 3.1 - Solaris/Netezza
XIR2, 6, 5.1.9 - Solaris/Weblogic/Oracle

WebI, CMC, Xcelcius/Dashboards4, BI Mobile, CR, BI Explorer, DeskI
Back to top
Dave Rathbun
Forum Advocate
Forum Advocate



Joined: 06 Jun 2002

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


flag
PostPosted: Tue Nov 03, 2009 3:00 pm 
Post subject: Re: Universe Documentor (Dwayne's plus a few extras)

No worries, please post back here when you're ready. The download is not available here so nobody will be able to download it until it's released. Only moderators can see attachments in this forum. You've probably noticed you can't even see your own attachment. icon_smile.gif
_________________
Dave's Adventures in Business Intelligence Image link

Latest Blog Posts
• 2019-09-19 Stephen Few Blog Post on Multivariate Visualization
• 2019-02-11 Update on Query Banding
• 2018-10-19 BI Evolution
Back to top
SandiR
Principal Member
Principal Member



Joined: 20 Dec 2004
ASUG Icon
Posts: 273
Location: By the sea


flag
PostPosted: Wed Nov 04, 2009 4:48 am 
Post subject: Re: Universe Documentor (Dwayne's plus a few extras)

Hi Dave

I have just double checked the util with the universe in question and the problem was in the universe after all (again, something not picked up by the integrity check process - invalid month/state on a date object).

So no changes required to the spreadsheet.

Cheers, Sandi

_________________
Sandi

Available for contract work throughout the UK from 1st September 17
uk.linkedin.com/pub/sandi-rocca/1b/262/776/

BI4 - Windows/Tomcat/SQL Server 2008
XI 3.1 - Solaris/Netezza
XIR2, 6, 5.1.9 - Solaris/Weblogic/Oracle

WebI, CMC, Xcelcius/Dashboards4, BI Mobile, CR, BI Explorer, DeskI
Back to top
SandiR
Principal Member
Principal Member



Joined: 20 Dec 2004
ASUG Icon
Posts: 273
Location: By the sea


flag
PostPosted: Fri Nov 05, 2010 8:13 am 
Post subject: Re: Universe Documentor (Dwayne's plus a few extras)

Hi Dave - did this ever get uploaded?

A few folk have contacted me over the last few months and I have emailed it out.

Cheers, Sandi

_________________
Sandi

Available for contract work throughout the UK from 1st September 17
uk.linkedin.com/pub/sandi-rocca/1b/262/776/

BI4 - Windows/Tomcat/SQL Server 2008
XI 3.1 - Solaris/Netezza
XIR2, 6, 5.1.9 - Solaris/Weblogic/Oracle

WebI, CMC, Xcelcius/Dashboards4, BI Mobile, CR, BI Explorer, DeskI
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19316
Location: Bratislava


flag
PostPosted: Sat Jan 01, 2011 2:55 pm 
Post subject: Re: Universe Documentor (Dwayne's plus a few extras)

Moderator note:
Finally moved to BOB's Downloads
Back to top
gauravsays
Senior Member
Senior Member



Joined: 01 Dec 2009

Posts: 42


flag
PostPosted: Wed Apr 27, 2011 8:18 am 
Post subject: Re: Universe Documentor (Dwayne's plus a few extras)

Hi,

i'm unable to download this...getting weird error (says file is corrupted). nopity.gif can you please mail me @ gaurav.satwalkar@synechron.com?

thank you,
gaurav
Back to top
SandiR
Principal Member
Principal Member



Joined: 20 Dec 2004
ASUG Icon
Posts: 273
Location: By the sea


flag
PostPosted: Wed Apr 27, 2011 8:41 am 
Post subject: Re: Universe Documentor (Dwayne's plus a few extras)

Hi Gaurav

Is is the download or when you try to run it?
I have just downloaded here with no error reported

Cheers,
Sandi

_________________
Sandi

Available for contract work throughout the UK from 1st September 17
uk.linkedin.com/pub/sandi-rocca/1b/262/776/

BI4 - Windows/Tomcat/SQL Server 2008
XI 3.1 - Solaris/Netezza
XIR2, 6, 5.1.9 - Solaris/Weblogic/Oracle

WebI, CMC, Xcelcius/Dashboards4, BI Mobile, CR, BI Explorer, DeskI
Back to top
gauravsays
Senior Member
Senior Member



Joined: 01 Dec 2009

Posts: 42


flag
PostPosted: Thu Apr 28, 2011 5:10 am 
Post subject: Re: Universe Documentor (Dwayne's plus a few extras)

Hi Sandi, yes, it's during download. banghead.gif

I'm getting error file corrupted. I tried downloading from several other machines in office but in vain. crazy.gif

can you please mail utilities mentioned below to my id gaurav.satwalkar@synechron.com

GetSetUniverse_3_6_01.xls:
http://www.forumtopics.com/busobj/viewtopic.php?t=141886

BOXI Universe Documentor v4.xls
http://www.forumtopics.com/busobj/viewtopic.php?t=144148

universedocumentor.zip
http://www.forumtopics.com/busobj/viewtopic.php?t=81527

what we are trying to do is document universes in excel & Web-I documents (what objects in them?) for inventory purpose using VBA or JSDK code.

Environment: BO XI 3.1, Tomcat 5.5, WebI: 12.3

Thank you in advance,
Gaurav Satwalkar
Back to top
ngosz1
Senior Member
Senior Member



Joined: 03 Dec 2010

Posts: 36
Location: Green Bay, WI


flag
PostPosted: Wed May 18, 2011 3:43 pm 
Post subject: Re: Universe Documentor (Dwayne's plus a few extras)

I liked this document...so I'm looking forward to the day this documenter is available for R3.1
Back to top
gwicker
Forum Member
Forum Member



Joined: 15 Mar 2007

Posts: 8


flag
PostPosted: Wed Jun 22, 2011 9:00 am 
Post subject: Re: Universe Documentor (Dwayne's plus a few extras)

I have been usin BOXI Universe Documentor V4 with great success. However due to a company policy I had to upgrade my pc to windows 7 with MS Offcie 2010. Now I am getting the error message "Failure in DocumentUniverse() VBO Project - 430: Class does not support Automation or does not suppot expect interface". Is there a fix for this? Will this program run in MS Excel 2010? I hope so. If it is not possible, is there another way I can document a universe. The BOE that I am connecting to is XI\R2.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Page 1 of 3 All times are GMT - 5 Hours
Goto page 1, 2, 3  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.0980 seconds using 20 queries. (SQL 0.0041 Parse 0.0669 Other 0.0270)
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