Where the table is used? (What reports are using determined table)

Question

I have many reports developed by many users in the company OBIEE system.

What i need is to find what reports are using determined table/column. Example:

The table FACT_COMPANY is used by:

REPORT_1

*Second Tab

REPORT_2

*Detail Tab

Etc...etc....

How can i find that?

Charles M · Answer

Have you checked into data lineage?

https://docs.oracle.com/middleware/11119/odi/develop-connectivity-km/biee_lineage.htm#ODIKM1496

Gianni Ceresa · Answer

The SampleApp (https://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html ) has some scripts which extract that kind of information and load them into the database and inside the same SampleApp you also have some "impact" analysis dashboards which allow you to find those kind of links.

There isn't a single "next next next" tool in OBIEE for that.