Tuesday, 2 January 2018

Part 1: Oracle Fusion BIP Reports: Step by Step process to Create BIP reports and Register in Oracle Fusion


Hi Friends , In this Post , We will discuss Oracle Fusion BIP Reports. I will show you step by step process for how to create an BIP report and how we can run the BIP report in Oracle cloud.

Before starting this post if you have not go through my last post for BIP reports then please go through it. Its recommended to go through that before starting creation BIP reports.

http://rpforacle.blogspot.in/2018/01/oracle-fusion-bip-reports-step-by-step-post-to-create-bip-report-and-register-in-fusion.html


Step 1:- Login to Oracle Fusion and go to Menu Navigator as below and Click on Reports and Analysis option.


Oracle Fusion BIP Reports

Step2:-

Step3:- Click on + sign and Data set will be open as below
Give the name of Data Set:= XX_INVOICE_DETAILS
Data Source:= ApplicaionDB_FSCM


Oracle Fusion BIP Reports
 
Step3:- Again Click on + sign and Data set will be open as below
Give the name of Data Set:= XX_SUPPLIER_SITES
Data Source:= ApplicaionDB_FSCM
 
 
Oracle Fusion BIP Reports
 
 



Step 5:- Now these two data sets has been created and now we will join these two group by data link so Click on Vendor_id column and select Create Link

Oracle Fusion BIP Reports
Step 5:- we will join these two group by data link so Click on Vendor_id column
Oracle Fusion BIP Reports
 
 
Step 7:- Now Save the Data model as below in right folder under Invoices Folder.
 
Oracle Fusion BIP Reports
 
 
 
Step 8:- Now we will Create Parameters. I am going to create Vendor Name parameter for this  as below.
Oracle Fusion BIP Reports
 
 
Step 10:-
Oracle Fusion BIP Reports
 
Step 11:-
 
Now we will create Value set and attach this Value set to Parameters.
 
Oracle Fusion BIP Reports
 
 
Step 12:- LOV Creation as below.
 
Oracle Fusion BIP Reports
 
 
Hi Friends due to the length of this topic I will split these topic three parts , I have split this topic in three parts. Please follow the next post for rest of the steps.
Part 2 Url:-
 
 
 
 
 
 Oracle Fusion BIP Reports

0 comments:

Post a Comment