Create a New Data Model for a HCM Report

Here's how to create a data model for an Oracle Business Intelligence Publisher report.

In this example, you create a data model using an absence by department analysis that you created previously.

Create a Data Model

  1. Navigate to the Reports and Analytics work area and click Browse Catalog to open the Oracle Business Intelligence Catalog.

  2. On the OBI EE home page under Create, Published Reporting, click More and select Data Model.

  3. On the Diagram tab, click New Data Set and select Oracle BI Analysis.

  4. In the New Data Set - Oracle BI Analysis window enter a name for your data model.

  5. In the Oracle BI Analysis field, click Search.

  6. In the Oracle BI Catalog window, click Users.

  7. Click the name of the person who created the analysis.

  8. Locate and select the absence by department analysis that you have previously created.

  9. In the Time Out field, enter 120.

  10. Click OK.

  11. Click the Structure tab.

  12. In the XML Tag Name field for the Department Name, replace the default value with DEPT_NAME, and replace the default value in the Display Name with Department.

  13. In the XML Tag Name field for the Absence Reason, replace the default value with ABSENCE_REASON, and replace the default value in the Display Name with Reason for Absence.

  14. In the XML Tag Name field for the Assignment Absences, replace the default value with NUMBER_ABSENCES, and replace the default value in the Display Name with Number of Absences.

  15. Click the Data tab.

  16. On the Data tab, click View.

  17. View the report structure and click Save As Sample Data.

  18. Click OK.

  19. In the upper-right corner, click Save.

  20. In the Save As window, select My Folders, and enter Absence by Department Data Model.