|
|
HC02.1 - Headcount and Turnover Data Mart Setup
Use Headcount-Turnover Data Mart Setup (HC02.1) to define the dimensions
and the criteria for each dimension in the OLAP database.
IMPORTANT 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.
WARNING 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.
**More Information
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.
Updated Files
HDCNTMART -
Referenced Files
ACIAACVDIM -
HREMPDIM -
HRHDCTMEAS -
HRIAAGE -
HRIAATTR -
HRIADIM -
HRIAJOB -
HRIAORG -
HRIAPERF -
HRIAPOS -
HRIASCH -
HRIASUP -
HRYEARS -
ORGSTRUC -
HC02.2 - Headcount and Turnover Measures
Use Turnover Submeasures (HC02.2) to define the members to roll up into a
turnover dimension.
**More Information
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
HDCNTDTL -
HDCNTGRP -
HRHDCTMEAS -
TRNOVERCAT -
TRNOVERDTL -
Referenced Files
HDCNTDTL -
HDCNTGRP -
PRSYSTEM -
ROLAPDIM -
TRNOVERCAT -
TRNOVERDTL -
HC02.3 - Headcount Group Criteria
Use Turnover Measure Criteria (HC02.3) to define the criteria used to
determine what to count in the turnover measure.
Updated Files
HDCNTDTL -
Referenced Files
EMSTATUS -
HDCNTGRP -
HRHDCTMEAS -
HC02.4 - Headcount Group Definition
Use Headcount-Turnover Employee Assignment Dimensions (HC02.4) with
HC02.1 (Headcount-Turnover Data Mart Setup) to define any employee assignment
dimensions that are to be included in the data mart.
Updated Files
HDCNTDTL -
HDCNTGRP -
Referenced Files
HDCNTDTL -
HRHDCTMEAS -
HC02.5 - Turnover Group Criteria
Use Headcount-Turnover Pay Related Dimensions (HC02.5) with HC02.1
(Headcount-Turnover Data Mart Setup) to define any pay related dimensions that
are to be included in the data mart.
Updated Files
PERSACTION -
TRNOVERCAT -
TRNOVERDTL -
Referenced Files
EMSTATUS -
HRHDCTMEAS -
HRUSERFLDS -
PADICT -
PCODES -
PERSACTYPE -
HC02.6 - Turnover Group Definition
Updated Files
TRNOVERCAT -
TRNOVERDTL -
Referenced Files
HRHDCTMEAS -
TRNOVERDTL -
INVOKED Programs
IAAP
IFOB
IADE
IART
|
