Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             IAYEARYR FILE

REFERENCED BY

IATS.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

IYY-USER-DIM-NAME    Alpha 50  (Lower Case)
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.


IYY-YEAR             Numeric 4
Last Closed Year     Contains the fiscal year for the data
                     stored on this record.



IYY-MEMBER-NAME      Alpha 50  (Lower Case)
Member Name          This is an override member name for
                     Data Mart dimensions with no association
                     to a Budget dimension.

                         IAYEARYR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IYYSET1   USER-DIM-NAME                                          IATS.1
          YEAR

IYYSET2   USER-DIM-NAME KeyChange
          MEMBER-NAME