system
October 21, 2013, 12:48pm
#1
Hi,
How to get list of table names and schemas used in a particular universe. I need to knoiw the schema names used in that universe. What am i doing is a manual process by checking all the tables in the universe.
I have 20 universes and few of them has morethan 200 tables and it is a tedious task.
Can someone please help if you have any better ideas?
Can it done by Query builder?
Please suggest
neetha_bo (BOB member since 2013-04-22)
system
October 21, 2013, 12:56pm
#2
Hi,
Check the BOB’s Download section. There are several utilities for documenting universes:
http://www.forumtopics.com/busobj/viewforum.php?f=25
Marek Chladny (BOB member since 2003-11-27)
system
October 22, 2013, 6:27am
#3
Thanks Marek. But I could not find any related stuff in the link provided by you. Can you please suggest
neetha_bo (BOB member since 2013-04-22)
system
October 22, 2013, 7:21am
#4
The first two non-sticky topics on the top are:
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…
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…
Have you not seen them?
Marek Chladny (BOB member since 2003-11-27)