1. Administering Data Integration for Oracle Enterprise Performance Management Cloud
  2. Integrating Data
  3. Integrating Oracle ERP Cloud Data
  4. Registering a BI Publisher Report as an Oracle Enterprise Scheduler (ESS) Job
  5. Creating the Data Model for the BI Publisher Report Extract

Creating the Data Model for the BI Publisher Report Extract

In this step you create the data model for the Oracle Business Intelligence Publisher report extract.

A data model is an object that contains a set of instructions for BI Publisher to retrieve and structure data for a report. Data models reside as separate objects in the catalog. At the very simplest, a data model can be one data set retrieved from a single data source (for example, the data returned from the columns in the employees table). A data model can also be complex, including parameters, triggers, and bursting definitions as well as multiple data sets.

To build a data model:

  1. In Oracle ERP Cloud under Tool, navigate to Report and Analytics.

    Image shows the Oracle ERP Tools page.

  2. When BI Publisher opens, click Browse Catalog.

    Image shows tge Reports and Analysis page.

    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.

  3. Click Data Model.

    Image shows Catalog page.

  4. From the Data Model page, select SQL Query.

    Image shows the Data Model page.

  5. Specify the name of the query and then in Type of SQL drop-down, select Standard SQL.

  6. In SQL Query, paste the SQL defined in the prior section and then click OK.

    Image New Data Set page.

  7. From the Add Parameter page, check the bind parameters to include and then click OK.

    Bind parameters are detected automatically.

    Image shows the Add Parameter page

  8. From the Data Model page, then Properties, then Data Sets, select the query.

    The query columns are displayed.

    Image shows the Data Model page.

  9. Select Properties to edit the group name as needed and then click OK.

    Image shows how to edit properties.

  10. 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.

    Image shows data in tree format.

    Image shows data in table format.

  11. Click Save as Sample Data.

    Sample data is required to build the report layout and to preview the report definition.

  12. 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.

  13. Confirm the row and click Save.

    Image shows the Data Model page

  14. You are prompted to select the location to which to save the data model.

    Image shows

  15. View the data model and make any edits in the BI Catalog once it has been saved.

    Image shows the Catalog page.

    After the data model has been saved, it can be used as the basis for the BI Publisher extract.