I am hoping that someone already has some SQL written to do this, that is why I am posting the question. If I select a particular object in a Universe, I need to know what documents that the object is being used in. Our repository is on Oracle 8i and we are using BO 5.1.
We are going to be changing some objects and I need to know exactly what documents are going to be affected by the change.
Can’t be done with SQL against the repository. There are, however, several options for working with a set of documents once they have been retrieved to your workstation. Here’s one approach that I use frequently.