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
-
Navigate to the Reports and Analytics work area and click Browse Catalog to open the Oracle Business Intelligence Catalog.
-
On the OBI EE home page under Create, Published Reporting, click More and select Data Model.
-
On the Diagram tab, click New Data Set and select Oracle BI Analysis.
-
In the New Data Set - Oracle BI Analysis window enter a name for your data model.
-
In the Oracle BI Analysis field, click Search.
-
In the Oracle BI Catalog window, click Users.
-
Click the name of the person who created the analysis.
-
Locate and select the absence by department analysis that you have previously created.
-
In the Time Out field, enter 120.
-
Click OK.
-
Click the Structure tab.
-
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.
-
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.
-
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.
-
Click the Data tab.
-
On the Data tab, click View.
-
View the report structure and click Save As Sample Data.
-
Click OK.
-
In the upper-right corner, click Save.
-
In the Save As window, select My Folders, and enter Absence by Department Data Model.