How to find database fields for an OBIEE report?

Often it is required to investigate what is the database source (table field) for an OBIEE report field(s) or to find out if in BI data model (repository) you can find a specific information(field).

To speed up the investigation process I have decide to export the BI repository documentation and in this way I'm able to quickly progress with my analysis and also to respond immediately to any kind of questions.

On one hand you have the OBIEE report with details about Subject area, Presentation Table and Presentation column and on the other hand BI repository documentation with complete details about Business Model, Logical Table, Logical Column, Logical Table Source, Database, Physical Catalog, Physical Schema, Physical Table and Physical Column.





If you have Oracle BIAPPS version 7.9.6.4 and you need to find what database fields not included into Physical layer you may take a look to Oracle Business Analytics Warehouse Data Model Reference . This is made up of three distinct pieces:
• The Oracle Business Intelligence Applications Naming Conventions and Domain Values Guide
• The star schema diagrams
• The table and column descriptions

This video will present below steps:
- Create a simple OBIEE report for required fields
- Connect to Admin tool and export repository documentation
- Open repository documentation and find database table and fields
- Query database table and fields using SQL developer

If you liked this article feel free to share it with your fellows. Thank you! 

For some other helpful videos check my YouTube Channel. 

To receive notifications for new articles follow me

Or subscribe by email

Email Address