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 to create a 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

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

Create a Report in BI Publisher

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