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

Darós

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?

Gianni Ceresa

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.

Charles M

Have you checked into data lineage?

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