Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Where the table is used? (What reports are using determined table)
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?
Answers
-
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.
0 -
Have you checked into data lineage?
https://docs.oracle.com/middleware/11119/odi/develop-connectivity-km/biee_lineage.htm#ODIKM1496
0
