BIP Reports Metadata

Question

Summary

Content

Hey,

Is there a way to extract the metadata information from BIP reports.

1. We are using OBIEE 12c - 12.2.1.2.0

2. DB is Oracle 12c

3. We require the column names to be precise. Any other information extract is great too

4. We need to be able to extract all column names. this is for a mapping exercise

Please let me know.

Regards

Ram

Thomas Dodds · Answer

While logged into xmlpserver (BI Publisher, not OBIEE), enter the Catalog, then do the following: * Download the parent folder containing all the data models you will need. (download is under the more... option) * Once downloaded, rename the .xdmz file to a .zip. You can now view the contents of the files. * Write a script in Linux or Windows to recursively rename as .ZIP all the nested XDMZ files underneath the parent folder. * Extract all of the _datamodel.xdm files underneath the data models' XDMZ files (now renamed as ZIP files). * Now you need to parse these files to extract the SQL. Note that the Data Model's Data Set SQL is located between the tags: