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 (159.0 KB)


SandiR :uk: (BOB member since 2004-12-20)

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 Rathbun :us: (BOB member since 2002-06-06)

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 :us: (BOB member since 2002-09-19)

That’s certainly valid and I appreciate your concern. My initial inclination was to keep them as separate topics as well.


Dave Rathbun :us: (BOB member since 2002-06-06)

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


SandiR :uk: (BOB member since 2004-12-20)

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


SandiR :uk: (BOB member since 2004-12-20)

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. :slight_smile:


Dave Rathbun :us: (BOB member since 2002-06-06)

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


SandiR :uk: (BOB member since 2004-12-20)

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


SandiR :uk: (BOB member since 2004-12-20)

Moderator note:
Finally moved to BOB’s Downloads


Marek Chladny :slovakia: (BOB member since 2003-11-27)

Hi,

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

thank you,
gaurav


gauravsays :india: (BOB member since 2009-12-01)

Hi Gaurav

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

Cheers,
Sandi


SandiR :uk: (BOB member since 2004-12-20)

Hi Sandi, yes, it’s during download. :hb:

I’m getting error file corrupted. I tried downloading from several other machines in office but in vain. :crazy_face:

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

GetSetUniverse_3_6_01.xls:
Document a BO Universe in Excel

BOXI Universe Documentor v4.xls
Universe Documentor (Dwayne's plus a few extras)

universedocumentor.zip
Universe Documentation Generator

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


gauravsays :india: (BOB member since 2009-12-01)

I liked this document…so I’m looking forward to the day this documenter is available for R3.1


ngosz1 :us: (BOB member since 2010-12-03)

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.


gwicker :us: (BOB member since 2007-03-15)

THIS For me also


ScrappyDoo :uk: (BOB member since 2008-08-15)

Try this guys: http://support.microsoft.com/kb/983246/en-us?fr=1

Let me know if this is the right cause … and the right resolution! :mrgreen:

Gôm


ghohm :fr: (BOB member since 2009-09-15)

Ran this on an XI3.1 Universe and it worked. Saved me a shed load of work!

Thanks.


clynham :uk: (BOB member since 2007-08-17)

Hi All

Just wondering if anyone has looked into whether it would be possible to document the unx files at XI4?

Cheers,
Sandi


SandiR :uk: (BOB member since 2004-12-20)

Hi,

There is no SDK in BO 4.0, so very likely the answer is no, it’s not possible.


Marek Chladny :slovakia: (BOB member since 2003-11-27)