HC02.1 - Headcount-Turnover Data Mart Setup
Use HC02.1 (Headcount-Turnover Data Mart Setup) to define the dimensions and
the criteria for each dimension in the OLAP database. You must define these
dimensions 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 dimension. You are
also required to define at least one measure.
You can use up to 20 dimensions at a time.
Note: When you create the cube for this Data Mart and plan to load more than
one time dimension, use the Incremental Load feature (not full updates). This
will create an error report that shows many duplicates, which should be
ignored
If you run the Time dimension on full load, prior time dimensions will be
lost because they would not be passed with each iteration. In addition,
employees that were passed previously, but not with the latest load would be
lost.
Updated Files
HRIADIM -
HRIAMBR -
Referenced Files
EMPLOYEE -
EMSTATUS -
HRCTRYCODE -
HRSECLEV -
HRUSERFLDS -
OLAPDBM -
PAEMPPOS -
PAPOSRULE -
PATHFIND -
PERSGROUP -
PGEMPLOYEE -
PRPROCGRP -
PRSAGHEAD -
PRSYSTEM -
HC02.2 - Turnover Submeasures
Use HC021.2 (Turnover Submeasures ) to define the members to roll up into a
turnover dimension.
This creates a hierarchy for a turnover measure. For example, you can use
the termination measure and then define a submeasure to split out the
different types of terminations:
Termination
Voluntary
Involuntary
Updated Files
HRIAMBR -
Referenced Files
HRIADIM -
HC02.3 - Turnover Measure Criteria
Use HC02.3 (Turnover Measure Criteria) to define the criteria used to
determine what to count in the turnover measure.
Updated Files
HRIAMBR -
PERSACTION -
Referenced Files
EMSTATUS -
HRIADIM -
HRUSERFLDS -
PADICT -
PCODES -
PERSACTYPE -
PRSYSTEM -
INVOKED Programs
HRFN
HRST
IAAP
IFOB
|
