Introduction
Creating BI Publisher reports in Oracle Fusion becomes easy once you know the steps. BI Publisher is a powerful tool that lets you design and generate reports in different formats, making it simple to handle your business data.
Note:- make sure you have the BI Author or BI Administrator role assigned. Without the right access, you won’t be able to create or run reports.
This guide takes you through the entire process—from building a data model to publishing your final report with clear step-by-step instructions.
Step-by-Step: how to create a data model and how to create a report.
Step1: – Log in to your Oracle Fusion Cloud account.
Step2:- In the navigation pane, Go to Tools > Reports and Analytics.
Step3:- Click Browse Catalog to open the BI Publisher screen.
Step4:- From the menu, select Create > Data Model.
Step5:- Click the + icon and choose SQL Query. This opens the SQL editor window
Step6:- In the popup:
- Enter a suitable name
- Select one of the Data Source from the list
- Choose Standard SQL as the Type of SQL
- Write your SELECT query.
Example:
SELECT * FROM PER_ALL_PEOPLE_F
- Click OK
Note: Since the text area is too small it’s better to use a 3rd party editor like Notepad++ or Visual code studio to write the SQL. After finishing the query just cut and paste it to the SQL text area
Step7: – Go to the Data tab (1) and click View (2). If the SQL is correct, you’ll see a sample of 5 records.
Step 8: – Click the Save icon (3) to save the data model with a suitable name and location.
Step9:- Click Save as Sample Data (4). This sample data is needed for creating the report.
Step10: Click Create Report (5). A new screen opens to design the report layout.
Step11: In the wizard, select Use Data Model, pick the data model you saved in Step 8, and click Next.
Step12:- Choose a layout. For a simple report, keep the default settings:
- Page: Portrait
- Layout: Table
Step13:- In the Create Table screen, drag and drop the required columns from the Data Source pane (left) into the layout (right). Then click Next.
Step14:- Save the Report by with a folder name
Step 15: Click Finish
Step16:- Run the report by clicking on the open button.
By following these steps, you can quickly create a BI Publisher report in Oracle Fusion. With the right access and a clear data model, designing reports becomes a smooth process, helping you present business data in a format that is both accurate and easy to use.
Want to skip all these steps? Learn how to run them in a single click with CloudSQL here.
