Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              IAYEAR FILE

REFERENCED BY

IART.1    IATS.1    IAYR.1

UPDATED BY

IA85.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

IAY-USER-DIM-NAME    Alpha 50  (Lower Case)                      IA85.1
User Dim Name        The User Dimension Name is the name
                     associated with the dimension in the
                     data mart outline. This user-defined
                     name can contain up to 50 alphanumeric
                     characters. For example, you might name
                     a dimension Fiscal Year or Organization.


IAY-MBR-PREFIX       Alpha 5  (Lower Case)
Member Prefix        This field allows the budget
                     administrator to prefix the budget
                     dimesnion member names with a value for
                     the transformation to the OLAP Data
                     Mart.

IAY-BEGINNING-YEAR   Numeric 4                                   IA85.1
Beginning Year

IAY-ENDING-YEAR      Numeric 4                                   IA85.1
Ending Year

IAY-PRIOR-YR-MBR     Alpha 50  (Lower Case)                      IA85.1
Prior Yr Mbr

                         IAYEAR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IAYSET1   USER-DIM-NAME KeyChange                                IA85.1  IA85.2
                                                                 IA85.3  IART.1
                                                                 IATS.1  IAYR.1