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    HC10.1    IAAP.1    IANM.1

UPDATED BY

CB590     IA100     IADM.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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

IDT-DEFN-PROGRAM       Alpha 5                                   CB590   IA100
Element: Defn Program  The Data Mart Setup Program field         IADM.1
                       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                                   CB590   IA100
Element: Meta Program  The Outline Build Program field           IADM.1
                       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                                   CB590   IA100
Element: Fact Table OptY = Yes                                   IADM.1
                       N = No

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

                       Value values are:
                       L = Lawson
                       U = User

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

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

IDT-ATTR-PROGRAM       Alpha 6
Element: Attr Program

IDT-CHG-TO-MEASURE     Alpha 1                                   CB590   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                                CB590   HC10.1
                                                                 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