How to create report in bi publisher

This section we walk through on create report in BI Publisher. The following are the summary of steps needed to create a Oracle BI report

1. Create a Data Model in BI Publisher

2. Create a Report in BI Publisher

Pre-Requisite

 A data source must be established before creating a data model or report. Click on the link to create an HR Data source connection in BI Publisher

 1. Create a Data Model in BI Publisher

A data model is a collection of object work together to produce data for a report to generate.A data model requires data to read; it might be a database table, excel file, LDAP, etc.  For this sample report creation, we have used HR schema COUNTRIES table to pull the country names. Let’s begin to create a Data Model in BI Publisher 

1. Login into BI Publisher as BI Administrator

2. Click New and select Data Model from the drop down

3. Click on the Save icon to save the data model, create a folder and input a folder name for where you want to save the data model, input a data model name and Click Save

4. Now click Add and select SQL Query

5. Input a name, Select the data source as HR (See Prerequisite), Click On the Query Builder, Select Country table, Select the field Country Name. Click Save and Ok again. The BI Publisher wrote the query for you.

6. Click on the DATA tab, Click View and & Click Save a Sample Data

7. Click on the properties, ensure the sample.xml will be present, and click Save

We are done creating a data model. 

 

Create a Report in BI Publisher

A report is simply read data from a data model and visualize in a  graphical report. BI Publisher supports many visual formats like chart, graphs, table etc. For this demo purpose, we read the country names from the data model and display it in a table. 

Let’s begin to create a BI Publisher report  

8. Click New and select Report

9. Choose the Data Model you just created above and open it

10. Select the table and click Next

11. Choose the Country_Name & Click Next

12. Click View Report & Click Finish

13. Save the BI Publisher report with the same name in the same folder where you saved the Data Model

14. The BI Publisher Report run immediately. Change the report output if you want. That’s it we are done creating and running BI Publisher report

15. Click on the Catalog, select the folder where you created the data model and report. Click Open to run the BI Publisher report again and edit to modify it further. J