1,013 total views, 27 views today

How to create report in bi publisher

 

032817_0543_Createyourf1 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

 

032817_0543_Createyourf2 How to create report in bi publisher

 

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

 

032817_0543_Createyourf3 How to create report in bi publisher

 

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

 

032817_0543_Createyourf4 How to create report in bi publisher

 

4. Now click Add and select SQL Query

 

032817_0543_Createyourf5 How to create report in bi publisher

 

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.

 

032817_0543_Createyourf6 How to create report in bi publisher

 

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

 

032817_0543_Createyourf7 How to create report in bi publisher

 

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

 

032817_0543_Createyourf8 How to create report in bi publisher

 

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

 

032817_0543_Createyourf9 How to create report in bi publisher

 

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

 

032817_0543_Createyourf10 How to create report in bi publisher

 

10. Select the table and click Next

 

032817_0543_Createyourf11 How to create report in bi publisher

 

11. Choose the Country_Name & Click Next

 

032817_0543_Createyourf12 How to create report in bi publisher

 

12. Click View Report & Click Finish

 

032817_0543_Createyourf13 How to create report in bi publisher

 

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

 

032817_0543_Createyourf14 How to create report in bi publisher

 

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

 

032817_0543_Createyourf15 How to create report in bi publisher

 

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

 

032817_0543_Createyourf16 How to create report in bi publisher

govindan How to create report in bi publisher
Connect me

Govind

Thank you for visiting my personal blog. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life.

The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.

Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply 🙂
govindan How to create report in bi publisher
Connect me
Like us on Facebook.
Connect!