BI Publisher Reports in Oracle Fusion: Creating First Report

BI Publisher Reports in Oracle Fusion: Creating First Report

In my last post we taught about creating your first data model.

Now your data Model is ready so create First Report.


Go to New and click on Report to create a new report.

BI Publisher Reports in Oracle Fusion: Creating First Report


One popup will open, click on search button to choose you’re newly created Data Model.

BI Publisher Reports in Oracle Fusion: Creating First Report

Choose Sales_Data data model and click on open.

After that click on NEXT button.

Now choose Page Options and Layout. In my report I have chosen Landscape and Two charts and a table.

Now I will create my first report as Number of sales with respect to shipping mode.

So in value section I will drop sales column and in Series section I will drop Ship Mode.

BI Publisher Reports in Oracle Fusion: Creating First Report

You can preview the report by clicking on preview button.

BI Publisher Reports in Oracle Fusion: Creating First Report

Now I will create second Graph and in this I will show number of quantity ordered per day.

In value section add Order Quantity and in Label section add Order date, then click on next.

BI Publisher Reports in Oracle Fusion: Creating First Report

Now I will create final table by adding order Date, Order ID, Order Type, Sales, Discount and ship Mode. And click on next.

BI Publisher Reports in Oracle Fusion: Creating First Report

Now click on view report and Finish.

Note: We can also customize the report by clicking on customize report layout.

I will save it with the name of Sales_Report_2012. And click on view report to view the report.

BI Publisher Reports in Oracle Fusion: Creating First Report

BI Publisher Reports in Oracle Fusion: Creating First Report


So Here my report is s ready. Suppose you want edit the report.

So to edit the report You can go to Catalog.

BI Publisher Reports in Oracle Fusion: Creating First Report

You can see the thumbnail of your report again click on edit to edit the report

BI Publisher Reports in Oracle Fusion: Creating First Report


Here you can see various option to edit the report. To edit the Header double click on Header and give name as you want.

BI Publisher Reports in Oracle Fusion: Creating First Report


Here you can modify the color, Background color, size and font of the Text.

BI Publisher Reports in Oracle Fusion: Creating First Report


You can modify the chart as shown below

BI Publisher Reports in Oracle Fusion: Creating First Report


You can give 3D Look by clicking on 3D-Effect

BI Publisher Reports in Oracle Fusion: Creating First Report


You Can apply and manage filter by clicking on respective button as shown in figure.

BI Publisher Reports in Oracle Fusion: Creating First Report


Now as shown below Order Date in column is not looking good, so I want to modify the format of the Date. Click on any value

BI Publisher Reports in Oracle Fusion: Creating First Report

BI Publisher Reports in Oracle Fusion: Creating First Report


There are various options are there you can try for editing.

For now you can save your report and can see the final changes.

I will be covering some advance topics in later post.

Leave a Reply