Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMIACALDIX


                            AMIACALDIX FILE

REFERENCED BY

AMPD.1    AMYR.1    AMDL.1

UPDATED BY

AM88.4    AM88.5    AM88.6

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ITX-CAL-DIMENSION      Alpha 50  (Lower Case)                    AM88.4  AM88.5
Element: Cal Dimension                                           AM88.6

ITX-MBR-TYPE           Alpha 2                                   AM88.4  AM88.5
Element: Member Type   The Asset Member Type field specifies     AM88.6
                       the  member type.

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

ITX-SEQUENCE           Numeric 6
Element: Sequence      The Sequence field show the sequence of
                       a member as it is entered in either the
                       Budget Member Names or Fiscal Year
                       Variances subforms in AC87.1 (Financial
                       OLAP Dimensions).

ITX-YEAR               Numeric 4                                 AM88.4  AM88.5
Element: Last Closed YeContains the fiscal year for the data     AM88.6
                       stored on this record.


ITX-QUARTER            Numeric 1                                 AM88.4  AM88.5
Element: Quarter       Contains the fiscal quarter for the       AM88.6
                       data stored in this record.

ITX-PERIOD             Numeric 2                                 AM88.4  AM88.5
Element: Last Closed PeThis is the period for the record.        AM88.6

ITX-MEMBER-NAME        Alpha 50  (Lower Case)                    AM88.4  AM88.5
Element: Member Name   This is an override member name for       AM88.6
                       Data Mart dimensions with no association
                       to a Budget dimension.

                         AMIACALDIX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ITXSET1   CAL-DIMENSION                                          AM88.4  AM88.5
          MBR-TYPE                                               AM88.6  AMPD.1
          YEAR                                                   AMYR.1
          QUARTER
          PERIOD

ITXSET2   CAL-DIMENSION                                          AMDL.1
          MBR-TYPE
          YEAR*
          QUARTER*
          PERIOD*

                         AMIACALDIX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amiacaldim     AMIACALDIM   Required

                            ITX-CAL-DIMENSION    -> ITD-CAL-DIMENSION