Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Tables used by BIP reports

Received Response
12
Views
2
Comments
Rajesh Dhanapal
Rajesh Dhanapal Rank 4 - Community Specialist

Hi,

We have both OBIEE analysis and BIP reports in our OBIEE estate and now we need to trace the tables that you are used across all these reports. For OBIEE analysis, its quite easy to trace the tables via the Administration tool. However we have significant number of BIP reports. Although we have configured IAU schema, it will not give the physical tables that is used in the BIP data model SQL. Is there any other way to get the list of tables used in BIP report rather than going through the individual reports?

Any inputs will be highly appreciated.

Best regard,

Rajesh Dhanapal.

Answers