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.
One popup will open, click on search button to choose you’re newly created Data Model.
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.
You can preview the report by clicking on preview button.
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.
Now I will create final table by adding order Date, Order ID, Order Type, Sales, Discount and ship Mode. And click on next.
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.
So Here my report is s ready. Suppose you want edit the report.
So to edit the report You can go to Catalog.
You can see the thumbnail of your report again click on edit to edit the 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.
Here you can modify the color, Background color, size and font of the Text.
You can modify the chart as shown below
You can give 3D Look by clicking on 3D-Effect
You Can apply and manage filter by clicking on respective button as shown in figure.
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
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.