Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

HC01

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

    HRIADIM    -

    HRIAMBR    -

    MEMBER     -

    OLAPDBM    -

    OLAPDIM    -


Referenced Files

    APPLICTYPE -

    EMPLOYEE   -

    EMSTATUS   -

    HRSECLEV   -

    HRSUPER    -

    HRUSERFLDS -

    PAEMPPOS   -

    PAPOSRULE  -

    PATHFIND   -

    PERSGROUP  -

    PGEMPLOYEE -

    PRPROCGRP  -

    PRSAGHEAD  -

    PRSYSTEM   -


HC01.2 - Cash Compensation

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

    HRIAMBR    -


Referenced Files

    HRIADIM    -

    PRSYSTEM   -


INVOKED Programs

    HRFN
    HRST
    IFOB