I have a catalog of OBIEE reports which include many BI Publisher Reports. I want the SQL queries (and eventually the list of physical tables) used in the data models of all the BIP Reports in my catalog. I don't want to do it by manually going into each data model as there are hundreds of BIP reports. Is there a way to do that?
Related to that, we looking into analyzing all the XML files for the reports through a python script.
Is there a way I can extract the SQL queries from a XML file with or without using a Python script?
Any insight would be appreciated
The BI Publisher base tables all start with XDO. You can query the ALL_OBJECTS table to list all the XDO tables.
Check XDO_DS_DEFINITIONS_B table for the data definitions.