system
March 1, 2011, 4:47pm
3
There are two utilities in the BOB’s Downloads area that will extract universe information into XLS. Note: these will not work in BI 4.0 as the new Information Design Tool does not currently offer an SDK.
But for now, one of these should work:
Author: Dwayne Hoffpauir, EDS Corporation
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]Database tables
Database columns
Joins
Contexts
Classes
Objects
Conditions[/list]
[Moderator Edit: Added BI4 Download Link in this post - Dave Rathbun]
Document a…
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…
Dave Rathbun (BOB member since 2002-06-06)
(BOB member since 2002-06-06)