system
#1
We have a change in our database that means we need to check our universes to see if the column in question is used in any joins, object, etc
Under version 6 we used to just query the repository tables to see if the column name appeared there.
Is there a way we can query in XIr3.1 to do the same thing?
I know we can look at the audit database, but I’m not sure this info is stored there.
Appreciate any assistance on this problem.
norty303 
(BOB member since 2003-03-19)
system
#2
Hi,
Use either this utility:
or this one:
to document your universes. Then you should be able to get what you need from data from the excel files.
Marek Chladny 
(BOB member since 2003-11-27)
system
#3
Have you looked at Metadata Management? It would give you the lineage information for the columns to objects to reports.
tracyn712 (BOB member since 2008-06-05)