Tuesday 2 January 2018

What is Oracle Fusion BIP Reports. Difference in Oracle Fusion BIP and Oracle RDF

What is Oracle Fusion BIP Reports. Difference in Oracle Fusion BIP and Oracle RDF


Hi Friends , We are going to discuss about 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. We will also discuss What is Oracle Fusion BIP Reports and Difference in Oracle Fusion BIP and Oracle RDF. In this post , We will share the detail information about oracle fusion bip reports and the complete steps to create the BIP reports in Oracle Fusion.

In r12 , we do use Oracle Report Builder to Create RDF reports or we can also use XML publisher to create Oracle Reports but in Fusion , There is no Report builder and XML publisher kind of thing. In Fusion Oracle has provided business intelligence publisher(BIP) to design and create our custom reports.

Free Oracle Fusion Certifications Dump's (Click to Download)

Oracle Fusion has divided the Oracle Reporting system in 2 Parts.


1.OTBI (Oracle Transactional Business Intelligence).
2.BIP (Business intelligence publisher)

What is Oracle Fusion BIP Reports
What is Oracle Fusion BIP Reports

OTBI:-

The difference between OTBI and BIP is that , OTBI is the standard reporting system like Oracle standard reports in r12. But in r12 we or user did not have that flexibility to change its output as per the requirement but in Oracle fusion Oracle has provided this feature through OTBI. In OTBI oracle has provided standard Data Models( Data models is same as Oracle RDF data model used to built sql query and fetch data) and provided standard layouts also but there is also flexibility in the OTBI is this user can use the standard data model and change the report output as per the need so its quite user friendly reporting system.

Second this in OTBI ,Oracle has created Data models for most of its important data tables so user can create reports on any data bases on these data models. But we cannot do changes in Standard OTBI Data Models but there is a provision by which we can do change in the standard data model but then we need to save it in a Different name.

BIP :-

BIP is the customize reporting tool. Oracle Fusion has provided BIP to create custom reports or to meet the need of the business which is not achievable through OTBI reporting tool.

BIP is most similar like Oracle RDF report in which we creates Data Models , Different -2 groups then Link groups with Data Links. We can create Before and After Report triggers in form of event triggers. We can Create Parameters and List of Values also. We can also use custom Package also in the BIP.

But in Oracle R12 , we have very important useful tool set  that Formula Columns , Placeholder and summary columns but these tool set is not available in BIP reports. We can do some calculation in BIP on columns but we cannot write separate code in BIP like Formula column in Oracle RDF. This is a Big limitation in BIP reports because Formula Columns and Placeholder and Summary Columns quite useful in designing Complex reports.

We can also create Lexical Parameters in Oracle Fusion BIP reports so that we can change the report query dynamically based on conditions. We can creates Lexical parameters with the help of Event trigger but this is also possible if you using Oracle Fusion PAAS service if you are using Oracle Fusion SAAS then you cannot use Event Triggers.

Complete Tax Setups in Oracle Fusion

Step by Step to Create the Oracle Fusion BIP Reports

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


What is Oracle Fusion BIP Reports. Difference in Oracle Fusion BIP and Oracle RDF
What is Oracle Fusion BIP Reports. Difference in Oracle Fusion BIP and Oracle RDF

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


What is Oracle Fusion BIP Reports. Difference in Oracle Fusion BIP and Oracle RDF
What is Oracle Fusion BIP Reports. Difference in Oracle Fusion BIP and Oracle RDF

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


What is Oracle Fusion BIP Reports. Difference in Oracle Fusion BIP and Oracle RDF
What is Oracle Fusion BIP Reports. Difference in Oracle Fusion BIP and Oracle RDF




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

What is Oracle Fusion BIP Reports. Difference in Oracle Fusion BIP and Oracle RDF
What is Oracle Fusion BIP Reports. Difference in Oracle Fusion BIP and Oracle RDF
Step 5:- we will join these two group by data link so Click on Vendor_id column
What is Oracle Fusion BIP Reports. Difference in Oracle Fusion BIP and Oracle RDF
What is Oracle Fusion BIP Reports. Difference in Oracle Fusion BIP and Oracle RDF


Step 7:- Now Save the Data model as below in right folder under Invoices Folder.


What is Oracle Fusion BIP Reports. Difference in Oracle Fusion BIP and Oracle RDF
What is Oracle Fusion BIP Reports. Difference in Oracle Fusion BIP and Oracle RDF



Step 8:- Now we will Create Parameters. I am going to create Vendor Name parameter for this  as below.
What is Oracle Fusion BIP Reports. Difference in Oracle Fusion BIP and Oracle RDF
What is Oracle Fusion BIP Reports. Difference in Oracle Fusion BIP and Oracle RDF


Step 10:-

What is Oracle Fusion BIP Reports. Difference in Oracle Fusion BIP and Oracle RDF
What is Oracle Fusion BIP Reports. Difference in Oracle Fusion BIP and Oracle RDF



For rest of the BIP report creation steps , Please go through the Below Post.


To Learn OAF Online from Beginning , Please go to the OAF Tutorial


What is Oracle Fusion BIP Reports. Difference in Oracle Fusion BIP and Oracle RDF



9 comments:

12345 said...

Good Blog , Thanks for sharing this informative article.
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Oracle Fusion Financials Online Training
Big Data and Hadoop Training In Hyderabad

Anonymous said...

Wonderful blog I visit this blog it's incredibly awesome. Curiously, in this blog content formed doubtlessly and sensible. The substance of information is helpful.
Oracle Fusion HCM Online Training

Anonymous said...

Good blog, Thanks for sharing this informative article. It would be helpful to all if you write a full article.
Oracle Fusion HCM Online Training"

shaik shah said...

Good blog, Thanks for Sharing informative article. It would be helpful to all.
Oracle Fusion HCM Online Training

yamuna said...
This comment has been removed by the author.
raveena said...

coolest article
Oracle Fusion HCM Training

rainbow brammi said...

good information thanks for sharing
Oracle Fusion HCM Online Training

KITS Technologies said...

hadoop online training
online trining for hadoop bigdata

Anonymous said...

Good and nice contents for learning purpose

Post a Comment

Contact us for any Collaboration, Project Support & On Job Support Work

Name

Email *

Message *