How to get the reports using a table from the repository?

[system]

Hi,

I have a table TTL from a universe,Now is there any way I can find out how many reports are using objects from this particular table in BO 6.5.1

Can somebody tell me the SQL query which I can run on repository DB to find out this information.

Regards
Shikha

---

shikha (BOB member since 2008-03-12)

[system]

Hi

Do search on the BOB downloads, you can find a couple of topics meeting your requirement…

http://www.forumtopics.com/busobj/viewforum.php?f=25

Regards

Siva.M

---

looksmee (BOB member since 2006-02-08)

[system]

Sorry!!!But I didn’t find any post specific to this topic for 6.5.1 version

Shikha

---

shikha (BOB member since 2008-03-12)

[system]

Hi

You can get a utility where it will meet half of your requirement in the downloadable area, Like list of objects used in a report and like that…i dont think that you can get an utility directly speaks out your requirement. example is the one…

List objects used in a series of reports

Author: [url=http://www.forumtopics.com/busobj/profile.php?mode=viewprofile&u=1343]Dwayne Hoffpauir, EDS[/url] The attached utility will record objects that are used in a series of reports. Usage is as follows: [quote:61cb8b7957="Author's notes"]- Create a temporary directory. - Place all documents (.rep files) to be analyzed in that directory. - Place this document in that same directory. - Open this document, and refresh. - Each document in the directory will be opened, and data provider ob…

Regards

Siva.M

---

looksmee (BOB member since 2006-02-08)