Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IAYEAR


                              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
Element: 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)
Element: Mbr 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
Element: Beginning Year

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

IAY-PRIOR-YR-MBR       Alpha 50  (Lower Case)                    IA85.1
Element: 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