Prerequisite Tasks

The list of prerequisite processes you need to run, before using the subject areas for OTBI reporting are provided.

HCM OTBI Subject Areas use data from certain tables which are mostly added for reporting purposes. The data in these tables are populated based on some scheduled processes in HCM. Hence, you need to run these processes as a prerequisite, before using the subject areas or schedule them regularly.

Process Name	Subject Area(s) – Using This Data	Specific Dimensions	Comments
Refresh Manager Hierarchy	All subject areas that have the manager hierarchy dimensions	Assignment Manager Assignment Manager (Unsecured) Assignment Manager List Assignment Manager List (Unsecured) Matrix Manager Parent Managers	Refer Refresh Manager Hierarchies
Generate Daily Breakdown of Absence Details	Workforce Management – Absence Calendar Details Real Time		This process breaks down the absences by day, based on the start and end date of the absence. This is available in the Workforce Management – Absence Real time subject area.
Refresh Representative Data	Workforce Management - Areas of Responsibility		You need to run the process Refresh Representative Data to render the latest areas of responsibility(AOR) data of the workers, through this subject area.
Archive Workflow Tasks	Human Capital Management - Approval Notification Archive Real Time		To view the BPM data in OTBI subject area, it's required to run the ESS job, 'Archive Workflow Tasks'.
Calculate Seniority Dates	Workforce Management - Person Seniority Real Time		Person level seniority dates based on V3 seniority changes in the application are available for reporting using this subject area.