Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            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
Dimension Nbr

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

IDT-SYSTEM-OWNER     Alpha 2                                     IA100
System Owner

IDT-DEFN-PROGRAM     Alpha 5                                     IA100   IADM.1
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                                     IA100   IADM.1
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
Fact Table Opt       Y = Yes
                     N = No

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

                     Value values are:
                     L = Lawson
                     U = User

IDT-TABLE-FORMAT     Alpha 1                                     IA100
Table Format

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

                         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