How to Create BI Publisher Report in Oracle OEM

Create a Database Connection

Go to BI Publisher -> Administration->JDBC Connection

Create a Data Model

New->Data Model -> Upper Left ‘+’ icon -> SQL Query -> Data -> View -> Table View -> Save as Sample Data -> Top Right Save Data Model

Create a Report

Select Blank( Portrait ) -> Text Item ( for Header ) -> Drag “Data Table” -> Save ( Top Right ) -> Done

Schedule a Job

New -> Report Job ->Select a report to schedule …..

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.