Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ACIAMXDIM FILE

REFERENCED BY

ACBA.1

UPDATED BY

ACDM.9

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

AXD-DIMENSION-NAME   Alpha 50  (Lower Case)                      ACDM.9
Dimension Name       The Dimension Name field contains the
                     dimension name that is used by the OLAP
                     database.

                     Valid values are:
                     Year
                     Period
                     Measures
                     Scenario
                     Compton
                     Territory
                     Customer
                     Items

AXD-MX-DIM-TYPE      Alpha 10                                    ACDM.9
Mx Dim Type

AXD-MATRIX-CAT       Alpha 12                                    ACDM.9
Attribute            Attribute name assigned to an object
                     (like accounting unit) to track
                     additional information.  Attribute
                     values may then be used in selection and
                     sorting for report and analysis.

AXD-LEVEL-NBR        Numeric 3                                   ACDM.9
Level Nbr

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

                         ACIAMXDIM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AXDSET1   DIMENSION-NAME                                         ACBA.1  ACDM.2
          MX-DIM-TYPE                                            ACDM.8  ACDM.9
          MATRIX-CAT
          LEVEL-NBR

AXDSET2   DIMENSION-NAMEKeyChange                                ACDM.9
          MEMBER-NAME
          MX-DIM-TYPE
          MATRIX-CAT
          LEVEL-NBR