HC01.1 - Compensation Data Mart Setup
Use HC01. (Compensation Data Mart Dimensions) to define the dimensions and
the criteria for each dimension in the OLAP database. You must define the
dimensions in the OLAP database before you can define the database load
profile and populate the OLAP database using the OLAP Database Load program.
You are required to define information for the Employee and Measures
dimensions. The other dimensions are optional.
You can use up to 10 dimensions at a time.
Updated Files
HDTDIM -
Referenced Files
HRCOMPMEAS -
HREMPDIM -
HRIAAGE -
HRIAATTR -
HRIAJOB -
HRIAORG -
HRIAPERF -
HRIAPOS -
HRIASCH -
HRIASUP -
HRYEARS -
HC01.2 - Employee Dimension Definition
Use HC01.2 (Cash Compensation) to define the members to roll up into the Cash
Compensation dimension. Members are based on payroll records.
Updated Files
HREMPDIM -
Referenced Files
EMPLOYEE -
EMSTATUS -
HRIAATTR -
HRSECLEV -
IADIMATTR -
PAEMPPOS -
PAPOSRULE -
PATHFIND -
PERSGROUP -
PGEMPLOYEE -
PRPROCGRP -
PRSYSTEM -
HC01.3 - Employee Attributes
Updated Files
HRIAATTR -
Referenced Files
HREMPDIM -
IADIMATTR -
HC01.4 - Measures Dimension Definition
Updated Files
HRCOMPMEAS -
Referenced Files
HRCMEASX -
HC01.5 - Position Dimension Definition
Updated Files
HRIAPOS -
Referenced Files
None.
HC01.6 - Job Dimension Definition
Updated Files
HRIAJOB -
Referenced Files
HRIAATTR -
IADIMATTR -
HC01.7 - Additional Cash Compensation Measures
Updated Files
HRCMEASX -
Referenced Files
HRCOMPMEAS -
HC01.8 - Organization Dimension Definition
Updated Files
HRIAORG -
Referenced Files
None.
HC01.9 - Supervisor Dimension Definition
Updated Files
HRIASUP -
Referenced Files
None.
INVOKED Programs
IAAP
IFOB
IADE
IART
HCEA
HCJA
|
