Fusion: Steps to Create BI Publisher Report

Go To Navigator-> Reports and Analytics -> Browse Catalog

It will open Business Intelligence Catalog screen where Report can be developed following below steps.

Step-1 : Create Data Model

Click on “New” -> Data Model

Click on “New Data Set” -> SQL Query

Name : DataSet Name as DataSet1

Data Source : ApplicationDB_FSCM

Type of SQL : Standard SQL as Default value

Write your SQL query as below select * from po_headers_all

Click “OK”

And “Save” at the desired location.

Go To “Data” tab where we can select number of “Rows” to be displayed (max 200).

Click on “View” button to execute the SQL query of the Data Set

Data can be viewed as Tree View (XML) and Table View as well.

 Step 2 : Create Report/Layout

Click on “Export” button to get the XML and save to your Desktop using which Report Template (layout) can be built using BI Publisher

“Save As Sample Data” and “Create Report” option to upload the layout template.

“Use Report Editor” option and Click “Finish”.

Save at desire location

Click on “Upload“ option and give Layout Name (E.g. Output)

Select the Template file prepared using XML (Exported)

Select “Type” (E.g. RTF) and “Language” as English. Click “Upload”

Using “View Report” report output can be view as per the Templated designed.