Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MBRAUDIT


                             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.

UPDATED BY

IA120     IA150     IAMB.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MBA-DATA-MART-NAME     Alpha 20  (Lower Case)                    IA120   IA150
Element: Data Mart NameThis field contains the name of the data
                       mart.

MBA-DIM-OBJ-ID         Numeric 12                                IA120   IA150
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)                   IA120
Element: Audit File NamThe 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)                   IA120
Element: Attr File

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

                         MBRAUDIT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MBASET1   DATA-MART-NAMEKeyChange                                IA120   IA150
          DIM-OBJ-ID                                             IAMB.1