We had an inccident that one BO support person in our firm updated a universe and unintentionally add a never possible join (his unintentional drag&drop created a join something like Trade.Type = Trade.SalePerson). This went unnoticed causing all the production reports return blank.
We want to prevent this from happening again. We like to know what exactly changed before we update a universe.
Are there any tools or queries that can make diff of two universes? Any information/suggestions are appreciated.
BTW, we are using BO 6.5 on Solaris and the repository is on DB2 UDB8 database.
Thanks,
Min
zmin2001 (BOB member since 2007-05-23)