Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            AMIACALDIM FILE

REFERENCED BY

AMYR.1    AMDL.1    AMDM.1    AMPD.1

UPDATED BY

AM88.4    AM88.5

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ITD-CAL-DIMENSION    Alpha 50  (Lower Case)                      AM88.4  AM88.5
Cal Dimension

ITD-MBR-TYPE         Alpha 2                                     AM88.4  AM88.5
Member Type          The Asset Member Type field specifies
                     the member type.

                     Valid values are:
                     YR = Year
                     PD = Period
                     QR = Quarter

ITD-MEMBER-PREFIX    Alpha 5  (Lower Case)
Member Prefix

ITD-ALIAS-OPTION     Alpha 1
Alias Option

ITD-NBR-PERIODS      Numeric 2                                   AM88.5
Number of Periods    The Number of Periods field contains
                     the number of periods that are included
                     when the outline is built. This field
                     can contain up to two numeric values.


                         AMIACALDIM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ITDSET1   CAL-DIMENSION                                          AM88.4  AM88.5
                                                                 AMYR.1

ITDSET2   MBR-TYPE                                               AM88.4  AM88.5
          CAL-DIMENSION                                          AMDL.1  AMDM.1
                                                                 AMPD.1

                         AMIACALDIM FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amiacaldix     AMIACALDIX

                            ITD-CAL-DIMENSION    -> ITX-CAL-DIMENSION
                            ITD-MBR-TYPE         -> ITX-MBR-TYPE
                                                    ITX-YEAR
                                                    ITX-QUARTER
                                                    ITX-PERIOD