Step 1 : Creation of Data Model
Navigation : Navigator --> Reports and Analytics
Click on New Icon which is available on let side of BI home Page
Enter details
Name : Can give as per your Naming Standards (E. g SP_JOUR_DM)
Data Source : This can be selected based fusion DB Schema which we would like to access
Note :
ApplicationDB_FSCM ( Financial and Supply Chain Management )
ApplicationDB_HCM ( Human Capital Management )
ApplicationDB_CRM ( Customer Relationship Management )
Type of SQL: This is can based on Type of SQL which using for report
Standard SQL :Standard SQL used for normal SELECT statements interpreted to understand database schema
Procedure Call : query type to call a database procedure
To use REF cursor in Oracle BI Publisher :
Use this query type to issue SQL statements that can include the following:
Cursor statements that return nested results sets
Functions returning REF cursors
To use REF cursor in Oracle BI Publisher
In SQL Query Section we can provide Query If readily available . Otherwise can use Query Builder to Build Query for report
Step 2 : Creation of Report
Click on Create Report Which is available in BI Home Page
Default Data Model will selected Click On Next
Select Page Options : Portrait
Layout : Table
Click next
Drag Fields from Data Source --> Click Next
We can report output in Interactive Dashboard
To View or Download output in different format . Click on View report icon which is available in extreme right corner .
In Diagram tab click New Data Set -- SQL Query
Name : Can give as per your Naming Standards (E. g SP_JOUR_DM)
Data Source : This can be selected based fusion DB Schema which we would like to access
Note :
ApplicationDB_FSCM ( Financial and Supply Chain Management )
ApplicationDB_HCM ( Human Capital Management )
ApplicationDB_CRM ( Customer Relationship Management )
Type of SQL: This is can based on Type of SQL which using for report
Standard SQL :Standard SQL used for normal SELECT statements interpreted to understand database schema
Procedure Call : query type to call a database procedure
To use REF cursor in Oracle BI Publisher :
Use this query type to issue SQL statements that can include the following:
Cursor statements that return nested results sets
Functions returning REF cursors
To use REF cursor in Oracle BI Publisher
Click on Create Report Which is available in BI Home Page
Layout : Table
Click next
Drag Fields from Data Source --> Click Next
Click on Finish to Save report and View Output
To View or Download output in different format . Click on View report icon which is available in extreme right corner .
