BI Publisher Reports in Oracle Fusion: Creating Data Model from excel File

BI Publisher Reports in Oracle Fusion: Creating Data Model from excel File

To create your first in BI Publisher, first of all we need create a data model in BI Publisher taking data source as Excel File.

Follow the steps below to create a data model based on Microsoft Excel file.

Login to ORACLE Cloud and Navigate and click on BI Publisher link as shown in figure.

BI Publisher Reports in Oracle Fusion: Creating Data Model from excel File


It will redirect you to BI Publisher home page.

BI Publisher Reports in Oracle Fusion: Creating Data Model from excel File


Click on New and select Data Model

BI Publisher Reports in Oracle Fusion: Creating Data Model from excel File


Click on NEW DATA SET (+ sign) and select Microsoft Excel File.

Note: There are several options to create a data Model like using SQL Query, using LDAP Query,  using MDX Query,  using XML file, Web services. I will discuss about there in other posts.

BI Publisher Reports in Oracle Fusion: Creating Data Model from excel File


Name the Data Set as First Project (or something you like) and select Local button to select excel file from your Local Desktop.

BI Publisher Reports in Oracle Fusion: Creating Data Model from excel File


Choose file from your desktop and click on Upload. Here in My case Excel file name is Sales_Data_2012.xlsx.

BI Publisher Reports in Oracle Fusion: Creating Data Model from excel File


Your sheet name will appear as it is there in excel file. Click on OK.

BI Publisher Reports in Oracle Fusion: Creating Data Model from excel File


After upload is successful you can see the data diagram here.

BI Publisher Reports in Oracle Fusion: Creating Data Model from excel File


Then go to Data tab and save data as sample data and return back to Diagram tab.

BI Publisher Reports in Oracle Fusion: Creating Data Model from excel File


Now I want to create an Aggregate for sum of the sales, which we can do by clicking on menu.

BI Publisher Reports in Oracle Fusion: Creating Data Model from excel File


Then click on ADD Element by Expression.

BI Publisher Reports in Oracle Fusion: Creating Data Model from excel File


Follow the steps as shown in figure. Then validate expression if green color comes then click on OK.

BI Publisher Reports in Oracle Fusion: Creating Data Model from excel File

BI Publisher Reports in Oracle Fusion: Creating Data Model from excel File


Now we can see one more column added.

BI Publisher Reports in Oracle Fusion: Creating Data Model from excel File


Click on save and save it and give name as sales_data.

BI Publisher Reports in Oracle Fusion: Creating Data Model from excel File

BI Publisher Reports in Oracle Fusion: Creating Data Model from excel File


Now if you go to catalog you can see there you’re newly created Data Model.

Now go to New and click on Report to create a new report.

Now go to New and click on Report to create a new report

Now go to New and click on Report to create a new report.

Follow below link to create new report.

Creating First BI Publisher-reports-in-oracle-fusion

 

Leave a Reply