Oracle Fusion – Introduction To BIP


Oracle Fusion – Introduction To BIP


Navigate to “Reports and Analytics”


It is always recommended to create report in Custom folder so release won’t impact your custom reports.


Click on Browse Catalog to open BIP

Note BIP have different URL

There is another way we can open BIP is copy Fusion Cloud URL and append it by Analytics


Getting BIP Desktop Tool from BIP Home Page

Where are seeded Oracle reports stored


Click on “Data Model → Expand”

Open report from BIP


Creating New Report

Creating Data Model

Select Data Model from New dropdown.

Event Triggers and Flexfield are NOT used in SAAS model; it is used in on premise Fusion model.


Write a sql script in any of the familiar editor

  • LDAP and MDX are not being used yet, it will be used in future
  • Oracle BI Analysis: It is used for integrating OTBI reports with BIP, where we can choose source as OTBI to get OTBI data source.
  • CSV File: CSV File is used for importing external CSV file and generates a report on top of it. This feature can also be used as importing external table.
Select “SQL Query”


FSCM : For Finance application data source

HCM: For HCM application data source

CRM: For CRM application data source


Data tab can be used to view data in Tree structure or tabular format.

Adding binding variable


Adding List Of Value To Report



Save Report To Custom Folder

Creating BIP Report

First click on “Save As Sample Data” to save xml structure for creating template based report.


Click on Next

Click on Finish


Save the report to the folder on the server

Report output from server

End of session……

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s