Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SAIADIM


                              SAIADIM FILE

REFERENCED BY

SALD.1    SALO.1    SAMM.1    SAOR.1    SASC.1    SATE.1

UPDATED BY

SADM.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SA0-DATA-MART-NAME     Alpha 20  (Lower Case)                    SADM.1
Element: Data Mart NameThis field contains the name of the data
                       mart.

SA0-TIME-DIMENSION     Alpha 50  (Lower Case)                    SADM.1
Element: Time DimensionThe Time Dimension Name field contains
                       the user-defined name of the Time
                       dimension. This name can contain up to
                       30 characters of any kind.

SA0-YEAR-DIM           Alpha 50  (Lower Case)                    SADM.1
Element: Year Dim

SA0-MEASURE-DIM        Alpha 50  (Lower Case)                    SADM.1
Element: Measure Dim

SA0-SCENERIO-DIM       Alpha 50  (Lower Case)                    SADM.1
Element: Scenerio Dim

SA0-ORG-DIM            Alpha 50  (Lower Case)                    SADM.1
Element: Org Dim

SA0-TERRITORY-DIM      Alpha 50  (Lower Case)                    SADM.1
Element: Territory Dim

SA0-LOCATION-DIM       Alpha 50  (Lower Case)                    SADM.1
Element: Location Dim

SA0-CUSTOMER-DIM       Alpha 50  (Lower Case)                    SADM.1
Element: Customer Dim

SA0-PRODUCT-DIM        Alpha 50  (Lower Case)                    SADM.1
Element: Product Dim

SA0-DATA-LOAD-OPT      Alpha 1                                   SADM.1
Element: Data Load Opt The Data Values Load Option field
                       specifies how the data values are loaded
                       into the data mart.

                       Value values are:
                       N = No Load
                       I = Incremental
                       C = Complete; Default value.
                       A = Load all data
                       P = Partial data load

SA0-DATALD-BEG-PER     Numeric 2                                 SADM.1
Element: Datald Beg Per

SA0-DATALD-BEG-YR      Numeric 4                                 SADM.1
Element: Datald Beg Yr

SA0-DATALD-END-PER     Numeric 2                                 SADM.1
Element: Datald End Per

SA0-DATALD-END-YR      Numeric 4                                 SADM.1
Element: Datald End Yr

SA0-MAINT-DATE         Numeric 8  (yyyymmdd)                     SADM.1
Element: Maintenance DaThe date last changed.

SA0-MAINT-TIME         Numeric 6  (hhmmss)                       SADM.1
Element: Sys Time      The time last changed.

                         SAIADIM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SA0SET1   DATA-MART-NAME                                         SADM.1  SALD.1
                                                                 SALO.1  SAMM.1
                                                                 SAOR.1  SASC.1
                                                                 SATE.1