|
|
HRIADIM FILE
HR Datamart Dimensions
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-APPLIC-NAME Alpha 8 (Lower Case) HC01.1 HC02.1
Application Name The Application Name is the name of the
application that describes the database
names it contains. This user-defined
name can contain up to eight characters.
The first letter of the name must be
capitalized.
HID-DATABASE-NAME Alpha 8 (Lower Case) HC01.1 HC02.1
Database Name The Database Name is the name of the
database that is stored within the OLAP
application. Each application may
contain more than one database. This
user-defined name can contain up to
eight characters. The first letter of
the name must be capitalized.
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 15 (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
Companu
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 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 APPLIC-NAME HC01.1 HC01.2
DATABASE-NAME HC02.1 HC02.2
DIM-TYPE 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-APPLIC-NAME -> ODB-APPLIC-NAME
HID-DATABASE-NAME -> ODB-DATABASE-NAME
HRIADIM FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Members HRIAMBR
HID-APPLIC-NAME -> HIM-APPLIC-NAME
HID-DATABASE-NAME -> HIM-DATABASE-NAME
HID-DIM-TYPE -> HIM-DIM-TYPE
HIM-MEMBER-TYPE
HIM-SEQ-NBR
|