Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IACUSTMART


                            IACUSTMART FILE

REFERENCED BY

IA199     IA99.1

UPDATED BY

IA90.4

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IUM-ASP-CUSTOMER       Numeric 9                                 IA90.4
Element: Asp Customer

IUM-DATA-MART-NAME     Alpha 20  (Lower Case)                    IA90.4
Element: Data Mart NameThis field contains the name of the data
                       mart.

IUM-DATABASE-TYPE      Alpha 1                                   IA90.4
Element: Database Type E = Essbase
                       S = Microsoft Analysis Services

IUM-SERVER-NAME        Alpha 40  (Lower Case)                    IA90.4
Element: Server Name   The Server Name field contains the IP
                       address of the server to which you are
                       connecting. You can also specify a name
                       that has been associated with the server
                       (DNS name).

IUM-APPLIC-NAME        Alpha 8  (Lower Case)                     IA90.4
Element: Application NaThe Application Name is the name of the
                       application that describes the database
                       names it contains. This user-defined
                       name can contain up to eight characters.
                       The first letter of the name must be
                       capitalized.

IUM-DATABASE-NAME      Alpha 8  (Lower Case)                     IA90.4
Element: Database Name The Database Name is the name of the
                       database that is stored within the OLAP
                       application. Each application may
                       contain more than one database. This
                       user-defined name can contain up to
                       eight characters. The first letter of
                       the name must be capitalized.

IUM-AUTHENTICATE       Numeric 14
Element: Authenticate

IUM-ACTIVE-STATUS      Alpha 1                                   IA90.4
Element: Status        The status of the account. If Inactive,
                       no posting can be done to the account.


IUM-LOGIN              Alpha 30  (Lower Case)                    IA90.4
Element: Login

IUM-PROCESSING         Alpha 1
Element: Processing    The Processing field shows the current
                       status of the data mart. It provides a
                       locking mechanism to prevent updates
                       when data is being loaded to the data
                       mart.

                       Value values are:
                       ~ = No data is being processed
                       M = Outline build in process
                       D = Data load in process
                       C = Data mart calculation in process


IUM-JOB-NAME           Alpha 10
Element: Job Name

                         IACUSTMART FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IUMSET1   ASP-CUSTOMER  KeyChange                                IA199   IA90.1
          DATA-MART-NAME                                         IA90.4  IA99.1

IUMSET2   DATABASE-TYPE KeyChange, Subset                        IA90.4
          SERVER-NAME   Where DATABASE-TYPE = "E"
          APPLIC-NAME
          DATABASE-NAME

IUMSET3   LOGIN         KeyChange
          ASP-CUSTOMER
          DATA-MART-NAME

                         IACUSTMART FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iacustomer     IACUSTOMER   Required

                            IUM-ASP-CUSTOMER    -> ICE-ASP-CUSTOMER  (ICESET1)

Iacustusrs     IACUSTUSRS   Required

                            IUM-LOGIN           -> IUU-LOGIN