Utilities/queries to compare two universes

[system]

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)

[system]

This topic might have some ideas for you…

Something that I have been working on is starting with this utility and writing code to extract info from two universes and then go through and compare the two extracts, all using MS Excel VBA code. It’s working quite well, although at the moment I don’t include joins.

---

Dave Rathbun (BOB member since 2002-06-06)