 |
Lawson Insight Technical Documentation |
|
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
|