HC01.1 - Compensation Data Mart Setup
Use Compensation Data Mart Setup (HC01.1) to define the dimensions and
the criteria for each dimension in the OLAP database.
**More Information
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 -
HRIADIM -
HRIAJOB -
HRIAORG -
HRIAPERF -
HRIAPOS -
HRIASCH -
HRIASUP -
HRYEARS -
HC01.2 - Employee Dimension Definition
Use Cash Compensation (HC01.2) 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
|
