Oracle Fusion HCM OTBI - Chapter 2: Understanding Subject Areas in OTBI
📖 Content
What are Subject Areas in OTBI?
Subject Areas in OTBI are prebuilt metadata models that organize data into logical groupings such as Workforce Management, Payroll, Absence, Talent, etc. These are based on real-time transactional data in Oracle Fusion.
Each Subject Area contains:
-
Facts – Numerical or measurable data (e.g., Salary, Absence Days)
-
Dimensions – Descriptive or categorical data (e.g., Department Name, Job Title)
Commonly Used Subject Areas in Fusion HCM:
-
Workforce Management – Worker Assignment Real Time
-
Used for core employee data: name, assignment status, job, department.
-
-
Workforce Management – Person Real Time
-
Used for personal details like DOB, nationality, marital status.
-
-
Workforce Management – Work Relationship Real Time
-
Useful for employee relationships like legal employer and business unit.
-
-
Compensation – Salary History Real Time
-
Tracks employee compensation and salary changes over time.
-
-
Absence Management – Absence Real Time
-
Tracks leave types, durations, and approvals.
-
-
Payroll – Payroll Balance Real Time
-
View payroll balances like gross pay, deductions, taxes.
-
Real-Time Scenario Example:
An HR Business Partner needs to find all employees hired in the last 30 days, along with their departments and managers. Use:
Subject Area: Workforce Management – Worker Assignment Real Time
Fields: Employee Name, Hire Date, Department, Manager
Best Practices for Using Subject Areas:
-
Choose a subject area that includes all required fields – OTBI doesn’t allow cross-subject area joins by default.
-
Use “Real Time” subject areas for the most current data.
-
Avoid using deprecated or unsupported subject areas.
No comments:
Post a Comment