IADIMTYPES – No description in the Lawson data dictionary

System
Analytic Architect (IA)
Prefix
IDT
Primary key
DIMENSION-NBR
Fields
12
Updated by
3 programs
Referenced by
5 programs

IADIMTYPES is a Lawson Analytic Architect table (prefix IDT); no description in the lawson data dictionary. It is indexed by DIMENSION-NBR (IDTSET1); alternate indexes: IDTSET2, IDTSET3 and IDTSET4. It is related 1:M to ROLAPDIM. It is updated by CB590, IA100 and IADM.1 and referenced by HC10.1, IA02.1, IA02.2, IAAP.1 and IANM.1. The table has 12 fields, 4 indexes and 1 documented relation.

About IADIMTYPES

No description in the Lawson data dictionary.

Fields (12)

Column = COBOL field name without the IDT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#IDT-DIMENSION-NBR PK
DIMENSION_NBR		Numeric 3—CB590, IA100, IADM.1
#IDT-LAW-DIM-NAME SET2
LAW_DIM_NAME		Alpha 50 (Lower Case)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.CB590, IA02.1, IA100, IADM.1
#IDT-DESCRIPTION SET3 SET4
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.CB590, IA100, IADM.1
#IDT-SYSTEM-OWNER SET4
SYSTEM_OWNER		Alpha 2—CB590, IA100
#IDT-DEFN-PROGRAM
DEFN_PROGRAM		Alpha 5The 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.CB590, IA100, IADM.1
#IDT-META-PROGRAM
META_PROGRAM		Alpha 6The 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.CB590, IA100, IADM.1
#IDT-FACT-TABLE-OPT
FACT_TABLE_OPT		Alpha 1—
  • Y Yes
  • N No
CB590, IA100, IADM.1
#IDT-DIMENSION-TYPE
DIMENSION_TYPE		Alpha 1The Dimension Type field specifies the dimension owner. Value values are:
  • L Lawson
  • U User
CB590, IA100, IADM.1
#IDT-TABLE-FORMAT
TABLE_FORMAT		Alpha 1—CB590, IA100
#IDT-SORT-OPTION
SORT_OPTION		Alpha 1—
  • A Alphabetical
  • I Input Order
CB590, IA100
#IDT-ATTR-PROGRAM
ATTR_PROGRAM		Alpha 6——
#IDT-CHG-TO-MEASURE
CHG_TO_MEASURE		Alpha 1—CB590, IA100

Indexes (4)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
IDTSET1
  1. DIMENSION-NBR
Primary, KeyChangeIA02.1, IA02.2, IA100, IADM.1
IDTSET2
  1. LAW-DIM-NAME
KeyChangeCB590, HC10.1, IA02.1, IA100, IAAP.1, IADM.1, IANM.1
IDTSET3
  1. DESCRIPTION
  2. DIMENSION-NBR
KeyChange—
IDTSET4
  1. SYSTEM-OWNER
  2. DESCRIPTION
  3. DIMENSION-NBR
KeyChange—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ROLAPDIMIADIMTYPES

One to many (1) — child tables

RelationTableRulesConditionField map
RolapdimROLAPDIM
IDT-LAW-DIM-NAME→ROL-LAW-DIM-NAME (ROLSET4)
—→ROL-DIM-OBJ-ID

Programs

Updated by (3)

Referenced by (5)