Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             MBRAUDIT FILE

                              Member Audit

The Member Audit (MBRAUDIT) file contains the file name containing the member
names for each dimension. This file is used by IA120 (Data Mart Load) as
working storage.

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

MBA-DATA-MART-NAME   Alpha 20  (Lower Case)
Data Mart Name

MBA-DIM-OBJ-ID       Numeric 12
Dimension Object     The Dimension Object Identifier field
Identifier           contains a unique numeric identifier
                     assigned to the dimension, which
                     associates this record to the member
                     records.

MBA-AUDIT-FILE       Alpha 100  (Lower Case)
Audit File Name      The Audit File field contains the name
                     of the audit file containing all member
                     names that are loaded to the data mart.
                     These member names are also added to the
                     Analytic Architect system and are used
                     by the performance indicator mapping
                     feature.

MBA-ATTR-FILE        Alpha 100  (Lower Case)
Attr File

MBA-XML-FILE         Alpha 100  (Lower Case)
Xml File

                         MBRAUDIT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MBASET1   DATA-MART-NAMEKeyChange
          DIM-OBJ-ID