Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

HC02


HC02.1 - Headcount and 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

    HDCNTMART  -


Referenced Files

    ACIAACVDIM -

    HREMPDIM   -

    HRHDCTMEAS -

    HRIAAGE    -

    HRIAATTR   -

    HRIAJOB    -

    HRIAORG    -

    HRIAPERF   -

    HRIAPOS    -

    HRIASCH    -

    HRIASUP    -

    HRYEARS    -

    ORGSTRUC   -


HC02.2 - Headcount and Turnover Measures

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

    HDCNTDTL   -

    HDCNTGRP   -

    HRHDCTMEAS -

    TRNOVERCAT -

    TRNOVERDTL -


Referenced Files

    HDCNTDTL   -

    HDCNTGRP   -

    PRSYSTEM   -

    ROLAPDIM   -

    TRNOVERCAT -

    TRNOVERDTL -


HC02.3 - Headcount Group Criteria

Use HC02.3 (Turnover Measure Criteria) 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

This form is used 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

This form is used 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