Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IADIMTYPES


                            IADIMTYPES FILE

REFERENCED BY

IAAP.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IDT-DIMENSION-NBR      Numeric 3
Element: Dimension Nbr

IDT-LAW-DIM-NAME       Alpha 50  (Lower Case)
Element: 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)
Element: Description   This field displays the description.

IDT-SYSTEM-OWNER       Alpha 2
Element: System Owner

IDT-DEFN-PROGRAM       Alpha 5
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
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
Element: Fact Table OptY = Yes
                       N = No

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

                       Value values are:
                       L = Lawson
                       U = User

IDT-TABLE-FORMAT       Alpha 1
Element: Table Format

IDT-SORT-OPTION        Alpha 1
Element: 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