Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WOIADIM


                              WOIADIM FILE

REFERENCED BY

WODL.1    WOME.1    WOOR.1    WOSC.1

UPDATED BY

WODM.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

WOA-TIME-DIM           Alpha 50  (Lower Case)                    WODM.1
Element: Time Dim

WOA-YEAR-DIM           Alpha 50  (Lower Case)                    WODM.1
Element: Year Dim

WOA-MEASURE-DIM        Alpha 50  (Lower Case)                    WODM.1
Element: Measure Dim

WOA-SCENERIO-DIM       Alpha 50  (Lower Case)                    WODM.1
Element: Scenerio Dim

WOA-ORG-DIM            Alpha 50  (Lower Case)                    WODM.1
Element: Org Dim

WOA-PRODUCT-DIM        Alpha 50  (Lower Case)                    WODM.1
Element: Product Dim

WOA-DATA-LOAD-OPT      Alpha 1                                   WODM.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

WOA-DATALD-BEG-PER     Numeric 2                                 WODM.1
Element: Datald Beg Per

WOA-DATALD-BEG-YR      Numeric 4                                 WODM.1
Element: Datald Beg Yr

WOA-DATALD-END-PER     Numeric 2                                 WODM.1
Element: Datald End Per

WOA-DATALD-END-YR      Numeric 4                                 WODM.1
Element: Datald End Yr

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

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

                         WOIADIM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WOASET1   DATA-MART-NAME                                         WODL.1  WODM.1
                                                                 WOME.1  WOOR.1
                                                                 WOSC.1