Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              HRIADIM FILE

REFERENCED BY

HCAC.1    HCAG.1    HCCL.1    HCCP.1    HCEC.1    HCEM.1
HCEO.1    HCEX.1    HCGL.1    HCGN.1    HCJC.1    HCLO.1
HCMS.1    HCMS.2    HCOP.1    HCOP.2    HCPL.1    HCPO.1
HCRV.1    HCSC.1    HCSH.1    HCST.1    HCSU.1    HCTM.1
HCUF.1    HCUL.1    HCUN.1    HCYR.1

UPDATED BY

HC01.1    HC02.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

HID-DATA-MART-NAME   Alpha 20  (Lower Case)                      HC01.1  HC02.1
Data Mart Name

HID-DIM-TYPE         Numeric 3                                   HC01.1  HC02.1
Dim Type

HID-APPLIC-TYPE      Alpha 3                                     HC01.1  HC02.1
Application Type     The Application Type file stores the
                     names of the Lawson applications that
                     can be requested to supply information
                     to the OLAP database. The Lawson
                     applications that are currently
                     OLAP-ready are:

                     FIN = Financial Analyzer
                     FND = Daily Financial Analyzer
                     SA = Sales Analyzer
                     CX = Case Cart Analyzer
                     PO = Purchasing Analyzer
                     WO = Work Order Analyzer
                     CMP = Compensation
                     HDT = Headcount/Turnover

HID-DIMENSION-USE    Alpha 1                                     HC01.1  HC02.1
Dimension Use

HID-DIMENSION-NAME   Alpha 50  (Lower Case)                      HC01.1  HC02.1
Dimension Name       The Dimension Name field contains the
                     dimension name that is used by the OLAP
                     database.

                     Valid values are:
                     Year
                     Period
                     Measures
                     Scenario
                     Compton
                     Territory
                     Customer
                     Items

HID-DIM-PREFIX-1     Alpha 5                                     HC01.1  HC02.1
Dim Prefix 1

HID-DIM-PREFIX-2     Alpha 5                                     HC01.1  HC02.1
Dim Prefix 2

HID-DIM-PREFIX-3     Alpha 5
Dim Prefix 3

HID-DIM-ALIAS-OPT    Alpha 1                                     HC01.1  HC02.1
Alias Option

HID-DIM-BUILD-TO     Numeric 2                                   HC01.1  HC02.1
Dim Build To                                                     HCAG.1  HCCP.1

HID-COMPANY          Numeric 4                                   HC01.1  HC02.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.


HID-GROUP-NAME       Alpha 10                                    HC01.1  HC02.1
Group Name

HID-DATE-1           Numeric 8  (yyyymmdd)                       HC01.1  HC02.1
Date 1                                                           HCSC.1

HID-DATE-2           Numeric 8  (yyyymmdd)                       HC01.1  HC02.1
Date 2

HID-FACTOR-1         Signed 7.2                                  HC01.1  HC02.1
Factor 1

HID-SELECTION        Alpha 100                                   HC01.1  HC02.1
Selection

HID-DATE-STAMP       Numeric 8  (yyyymmdd)                       HC01.1  HC02.1
Date Stamp           This field contains the server date
                     (month, date, and year) of the last
                     change to this record.


HID-TIME-STAMP       Numeric 6  (hhmmss)                         HC01.1  HC02.1
Time Stamp           Contains the server time (hour, minute,
                     and second) when the record was last
                     changed.

HID-USER-ID          Alpha 10  (Lower Case)                      HC01.1  HC02.1
User ID Name         Contains the user ID of the person who
                     last changed this record.

                         HRIADIM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

HIDSET1   DATA-MART-NAME                                         HC01.1  HC01.2
          DIM-TYPE                                               HC02.1  HC02.2
                                                                 HC02.3  HCAC.1
                                                                 HCAG.1  HCCL.1
                                                                 HCCP.1  HCEC.1
                                                                 HCEM.1  HCEO.1
                                                                 HCEX.1  HCGL.1
                                                                 HCGN.1  HCJC.1
                                                                 HCLO.1  HCMS.1
                                                                 HCMS.2  HCOP.1
                                                                 HCOP.2  HCPL.1
                                                                 HCPO.1  HCRV.1
                                                                 HCSC.1  HCSH.1
                                                                 HCST.1  HCSU.1
                                                                 HCTM.1  HCUF.1
                                                                 ...

                         HRIADIM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required
                            When HID-COMPANY != Zeroes

                            HID-COMPANY           -> PRS-COMPANY
                            Spaces                -> PRS-PROCESS-LEVEL

Emp Group      PERSGROUP    Required
                            When HID-GROUP-NAME != Spaces

                            HID-COMPANY           -> PRG-COMPANY
                            HID-GROUP-NAME        -> PRG-GROUP-NAME

Olap Db        OLAPDBM      Required

                            HID-DATA-MART-NAME    -> ODB-DATA-MART-NAME

                         HRIADIM FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Members        HRIAMBR

                            HID-DATA-MART-NAME    -> HIM-DATA-MART-NAME
                            HID-DIM-TYPE          -> HIM-DIM-TYPE
                                                     HIM-MEMBER-TYPE
                                                     HIM-SEQ-NBR