Creating the BI Publisher Report

1- Creating the Data Model for the BI Publisher Report
In Oracle ERP Cloud under Tool, navigate to Report and Analytics.
When BI Publisher opens, click Browse Catalog.
A new tab opens where you can create a new data model. This is required for all BI Publisher extracts and is the source for the BI Publisher report.
Click Data Model.
From the Data Model page, select SQL Query.
Specify the name of the query and then in the Type of SQL drop-down, select Standard SQL.
In SQL Query, paste the SQL defined in the prior section and then click OK.
From the Add Parameter page, check the bind parameters to include and then click OK.
From the Data Model page, then Properties, then Data Sets, and select the query.
From the Data Model page, click the Data tab to view sample data for the query by entering sample values for the bind parameters.
Data may be viewed in both tree and table formats.
Click Save as Sample Data. "Sample data is required to build the report layout and to preview the report definition."
From the Data Model menu, navigate to Parameters, and then select Row Placement Order.
The order is important, and the same order should be defined in the report definition.
Confirm the row and click Save.
You are prompted to select the location to which to save the data model.
After the data model has been saved, it can be used as the basis for the BI Publisher Report.
2- Creating the BI Publisher Report
In BI Publisher, select New, then under Published Reporting, select the Report menu option to create a new report.
On the Create Report page, click Use Data Model to use an existing data model, and then from Create a report using an existing Data Model, select the data model and then click Next.
On the following page, leave the default values.
On the next page, uncheck the Show Grand Totals Row field at the bottom of the page.
On the same page, drag and drop the columns from the Data Source in the left pane to the layout area on the right page including all columns for the extract.
The displayed sample data is based on the sample data generated when you created the data model.
Click Finish. Save the report to the desired location.
After the report is saved, run the report to confirm that the data is displayed correctly. Then provide sample values for the bind parameters if needed.
Confirm the row placement order, edit the report, and confirm that the order is the same as the data model.

#OracleFusion #OracleFusionTechnical #OracleTechnical #BIPReport #PublisherReport