BIP Reports Metadata — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BIP Reports Metadata

Received Response
246
Views
1
Comments

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

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    While logged into xmlpserver (BI Publisher, not OBIEE), enter the Catalog, then do the following:

    1. Download the parent folder containing all the data models you will need. (download is under the more... option)
    2. Once downloaded, rename the .xdmz file to a .zip. You can now view the contents of the files.
    3. Write a script in Linux or Windows to recursively rename as .ZIP all the nested XDMZ files underneath the parent folder.
    4. Extract all of the _datamodel.xdm files underneath the data models' XDMZ files (now renamed as ZIP files).
    5. 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: