Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IADIMTYPES


                            IADIMTYPES FILE

REFERENCED BY

IA02.1    IA02.2    IAAP.1    IANM.1

UPDATED BY

IA100     IADM.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IDT-DIMENSION-NBR      Numeric 3                                 IA100   IADM.1
Element: Dimension Nbr

IDT-LAW-DIM-NAME       Alpha 50  (Lower Case)                    IA02.1  IA100
Element: Law Dim Name  The Lawson Dimension Name is the name     IADM.1
                       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)                    IA100   IADM.1
Element: Description   This field displays the description.

IDT-SYSTEM-OWNER       Alpha 2                                   IA100
Element: System Owner

IDT-DEFN-PROGRAM       Alpha 5                                   IA100   IADM.1
Element: Define ProgramThe 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                                   IA100   IADM.1
Element: 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                                   IA100   IADM.1
Element: Fact Table OptY = Yes
                       N = No

IDT-DIMENSION-TYPE     Alpha 1                                   IA100   IADM.1
Element: Dimension TypeThe Dimension Type field specifies the
                       dimension owner.

                       Value values are:
                       L = Lawson
                       U = User

IDT-TABLE-FORMAT       Alpha 1                                   IA100
Element: Table Format

IDT-SORT-OPTION        Alpha 1                                   IA100
Element: Sort Option   A = Alphabetical
                       I = Input Order

IDT-ATTR-PROGRAM       Alpha 6
Element: Attr Program

IDT-CHG-TO-MEASURE     Alpha 1                                   IA100
Element: Chg To Measure

                         IADIMTYPES FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IDTSET1   DIMENSION-NBR KeyChange                                IA02.1  IA02.2
                                                                 IA100   IADM.1

IDTSET2   LAW-DIM-NAME  KeyChange                                IA02.1  IA100
                                                                 IAAP.1  IADM.1
                                                                 IANM.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