Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMIACALDIM


                            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
Element: Cal Dimension

ITD-MBR-TYPE           Alpha 2                                   AM88.4  AM88.5
Element: 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)
Element: Member Prefix The Member Prefix field contains a
                       unique prefix to differentiate the
                       dimension name from other like-named
                       dimensions.  This user-defined name can
                       contain up to five characters of any
                       kind.

ITD-ALIAS-OPTION       Alpha 1
Element: Account Flag  The Alias Option field specifies the
                       alias option for the dimension.

ITD-NBR-PERIODS        Numeric 2                                 AM88.5
Element: Number of PeriThe 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