HC02.1 – Headcount and Turnover Data Mart Setup
- System
- Compensation D Mart (HC)
- Type
- Online screen — form 02
- Updates
- 1 table
- References
- 14 tables
HC02.1 (Headcount and Turnover Data Mart Setup) is a Lawson Compensation D Mart online screen (form 02, subform 1). It updates HDCNTMART and references ACIAACVDIM, HREMPDIM, HRHDCTMEAS, HRIAAGE, HRIAATTR, HRIADIM, HRIAJOB, HRIAORG and 6 more.
About HC02.1
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. Inaddition, 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 Loadprogram. 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 (1)
| Table | Description | System |
|---|---|---|
| HDCNTMART | No description in the Lawson data dictionary | HC |
Referenced files (14)
| Table | Description | System |
|---|---|---|
| ACIAACVDIM | No description in the Lawson data dictionary | AC |
| HREMPDIM | The HREMPDIM file contains the information used when building the Employee dimension. | HC |
| HRHDCTMEAS | No description in the Lawson data dictionary | HC |
| HRIAAGE | No description in the Lawson data dictionary | HC |
| HRIAATTR | The HRIAATTR data file contain the information required to build the attribute dimensions. | HC |
| HRIADIM | No description in the Lawson data dictionary | HR |
| HRIAJOB | No description in the Lawson data dictionary | HC |
| HRIAORG | No description in the Lawson data dictionary | HC |
| HRIAPERF | No description in the Lawson data dictionary | HC |
| HRIAPOS | No description in the Lawson data dictionary | HC |
| HRIASCH | No description in the Lawson data dictionary | HC |
| HRIASUP | No description in the Lawson data dictionary | HC |
| HRYEARS | No description in the Lawson data dictionary | HC |
| ORGSTRUC | Organization Structure | IF |
Program calls
Invoked programs (4)
IAAP, IADE, IART, IFOB