Creating BI Publisher Report in Oracle Fusion Cloud

 Creating BI Publisher Report in Oracle Fusion Cloud(OTBI)

1) Login to Oracle Fusion Cloud

2) Open "Reports And Analytics "

Click on Browse Catalog

3) Create Data Model Using Constructive Query

4) Save Data Model in "My Folder"

Click on Data --> View --> Table View --> Save as Sample data and Save Data Model by clicking save button icon in right top

Save in "My Folders" with name

5) Create Report Layout Using Data Model

 

Select the data model

Drag and drop required columns to report layout

6) Save the Report in "My Folder"

Sample Report Output

7) Assign the report to user and roles by placing in required folder location

Click on Browse Catalog again and copy the report

Choose "Shared Folders" and respective folder inside Custom folder, click on paste icon

Note: Custom folder will not be replaced by patches, otherwise the report may be lost when there is a new patch application.