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.