Oracle Business Intelligence Publisher
(BI Publisher, formerly XML Publisher) is an enterprise reporting
solution that streamlines report and form generation. A primary feature of
Oracle's BI Publisher product is the separation of the data extraction
process from the report layout. We Use BI Publisher to create highly complex reports which are pixel perfect. These kind of reports brings goods and services to the organization.
So in Fusion application we need to create BI report in following sequence :-
- Create Data Model
- Create Layout
- Create Report and schedule as per requirement.
Step 1 : Create Data Model
A data model is an object that contains a set of instructions for BI publisher to retrieve and structure data for a report. Data models reside as separate objects in the catalog
Step 2 :- Create layout of the report
If you get this error "Please save the data model before creating a new report":-
Then don't worry Just click ok and go back to the data model. Then click on view first followed by save as Sample data.
Now go back and click on create report . On the screen select the data model like below and select the guide me radio button and click on Next. Select the required option as per the requirement and click on next to proceed.
You will will be able to see report and export also. So we saw following features in BI reporting till now :-
Step 3 :- Schedule the BI report :-
Then don't worry Just click ok and go back to the data model. Then click on view first followed by save as Sample data.
Now go back and click on create report . On the screen select the data model like below and select the guide me radio button and click on Next. Select the required option as per the requirement and click on next to proceed.
Now drag and drop the fields you want to display in report and click on next.
Click on next to successfully to see the created report
Click on finish and save the report with appropriate name.
Best
Fit Reporting Type
•Interactive Reporting
•Production Reports
•Pixel
Perfect Reports
•Invoices, Purchase Orders, Financial
Statements…
Step 3 :- Schedule the BI report :-
BI Report jobs can be scheduled to run at defined intervals and to be delivered to the location or the required destination.
Steps are very easy go to catalog where the report is and click on more. There we can see an option schedule. Click on it like below screen shot.
You will be navigated to the new page like below :-
Follow the instructions as per above pic and submit your request .
Now to check the output of the report, go back to the catalog and click on more and then history . you will be able to see your report output.
Well that's all for this blog. Please comment below if you are able to create BI report in Fusion.
