Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IAYEARYR


                             IAYEARYR FILE

REFERENCED BY

IATS.1    IAYR.1

UPDATED BY

IA85.1    IA85.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IYY-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.


IYY-YEAR               Numeric 4                                 IA85.1
Element: Year          Contains the fiscal year for the data
                       stored on this record.


IYY-MEMBER-NAME        Alpha 50  (Lower Case)                    IA85.1  IA85.2
Element: 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                                          IA85.1  IA85.2
          YEAR                                                   IA85.3  IATS.1
                                                                 IAYR.1

IYYSET2   USER-DIM-NAME KeyChange
          MEMBER-NAME