IADIMTYPES FILE
REFERENCED BY
IAAP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IDT-DIMENSION-NBR Numeric 3
Dimension Nbr
IDT-LAW-DIM-NAME Alpha 50 (Lower Case)
Law Dim Name The Lawson Dimension Name is the name
of the Lawson defined dimension name.
Instead of the User Dimension Name, this
name is assigned by the Analytic
Architect system and is used by the
system that provides data to the
Analytic Architect system. If a user
changes the User Dimension Name, data
sent to the data mart is unaffected.
IDT-DESCRIPTION Alpha 30 (Lower Case)
Description This field displays the description.
IDT-SYSTEM-OWNER Alpha 2
System Owner
IDT-DEFN-PROGRAM Alpha 5
Define Program The Data Mart Setup Program field
contains the name of the program that
provides the dimensions, members, and
data selection parameters required by
the data mart.
IDT-META-PROGRAM Alpha 6
Meta Program The Outline Build Program field
contains the name of the program that
the Analytic Architect system calls to
supply the outline (description of the
data) to the data mart. This may be the
same program as the data values load
program.
IDT-FACT-TABLE-OPT Alpha 1
Fact Table Opt Y = Yes
N = No
IDT-DIMENSION-TYPE Alpha 1
Dimension Type The Dimension Type field specifies the
dimension owner.
Value values are:
L = Lawson
U = User
IDT-TABLE-FORMAT Alpha 1
Table Format
IDT-SORT-OPTION Alpha 1
Sort Option A = Alphabetical
I = Input Order
IADIMTYPES FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IDTSET1 DIMENSION-NBR KeyChange
IDTSET2 LAW-DIM-NAME KeyChange IAAP.1
IDTSET3 DESCRIPTION KeyChange
DIMENSION-NBR
IDTSET4 SYSTEM-OWNER KeyChange
DESCRIPTION
DIMENSION-NBR
IADIMTYPES FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Rolapdim ROLAPDIM
IDT-LAW-DIM-NAME -> ROL-LAW-DIM-NAME (ROLSET4)
ROL-DIM-OBJ-ID
|
