Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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
edited Aug 13, 2024 5:14PM in Oracle Analytics Cloud and Server

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