system
November 26, 2010, 7:02am
#1
I have 15 universes in my repository, my user want to see all the objects and filters etc in one excel; each universe objects has to be there in each tab in excel; is this possible with a VB macro? if any one have this macro pls share me. thank you.
raghaven (BOB member since 2007-05-01)
system
November 26, 2010, 7:06am
#2
Hi,
A good start can be either of these 2 universe-documenting utilities:
Author: [url=http://www.forumtopics.com/busobj/profile.php?mode=viewprofile&u=1343]Dwayne Hoffpauir, EDS[/url]
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:[list:5d8cd1056f]Database tables
Database columns
Joins
Contexts
Classes
Objects
Conditions[/list:u:5d8cd10…
Author: André Lützkendorf
Platform: Windows
Version: GetSetUniverse 3.5.25
Code: VBA code within the uploaded xls file
Author notes:
1. What can you do with the tool?
Presentation of all universe objects and properties
This includes
general universe information (defined in parameters)
all object properties
object dependencies (lineage/ impact analysis)
(which table will be used by which object,
which objects will be used by which objects with @functions)
contexts
hierarchies
joins
inc…
Marek Chladny (BOB member since 2003-11-27)
(BOB member since 2007-05-01)
(BOB member since 2003-11-27)