Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
BIP Reports Metadata

Summary
BIP Reports Metadata
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
Answers
-
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
<sql></sql>
tags:0