Analytic Architect – Lawson IA tables and programs

Analytic Architect (IA) in Lawson S3 v10 MSP6 has 47 tables, 63 online screens and 9 batch programs.

Tables (47)

TablePrefixDescriptionPrimary keyFields
ALIASTABLEALIAlias TableDATA-MART-NAME, ALIAS-TABLE4
APPLICTYPEIAAApplication TypeAPPLIC-TYPE10
ARBORRELABRArbor ReleaseRELEASE-NBR3
DATASOURCEDATData SourceDATA-MART-NAME, DATA-LOAD-NAME9
DIMDATARELDDRDimension Data SourceDATA-MART-NAME, USER-DIM-NAME, DATA-LOAD-NAME5
IAASPGROUPIAGNo description in the Lawson data dictionaryASP-GROUP5
IAATTRIBIATNo description in the Lawson data dictionaryDIM-OBJ-ID, ATTRIBUTE-NAME6
IACALCMBRCCMNo description in the Lawson data dictionaryDIM-OBJ-ID, MEMBER-NAME, RECORD-OWNER8
IACUSTMARTIUMNo description in the Lawson data dictionaryASP-CUSTOMER, DATA-MART-NAME11
IACUSTOMERICENo description in the Lawson data dictionaryASP-CUSTOMER10
IACUSTUSRSIUUNo description in the Lawson data dictionaryLOGIN5
IADESTTYPEDESNo description in the Lawson data dictionaryDATABASE-TYPE3
IADIMATTRIDBNo description in the Lawson data dictionaryLAW-DIM-NAME, ATTRIBUTE-NAME4
IADIMDLTDMXNo description in the Lawson data dictionaryDATA-MART-NAME, USER-DIM-NAME4
IADIMTYPESIDTNo description in the Lawson data dictionaryDIMENSION-NBR12
IADRILLIDRNo description in the Lawson data dictionaryDIM-OBJ-ID, DATA-TARGET, MBR-OBJ-ID, META-ID7
IAFILEDEFIFINo description in the Lawson data dictionaryUSER-DIM-NAME, DATA-MART-NAME, LEVEL-NBR, COLUMN-CAT, COLUMN-DESC11
IAFILEDLTDLTNo description in the Lawson data dictionaryDATA-MART-NAME, USER-DIM-NAME, COLUMN-DESC4
IAFORMULAIAFNo description in the Lawson data dictionaryFORMULA-NAME4
IAGRPDTLGDLNo description in the Lawson data dictionaryDATA-MART-GRP, DATA-MART-NAME3
IAGRPHDRGPMNo description in the Lawson data dictionaryDATA-MART-GRP3
IALOCALESIALLocalesDATA-MART-NAME, ALIAS-TABLE3
IASECURITYIASNo description in the Lawson data dictionarySECURITY-TYPE, DATA-MART-NAME, DIM-OBJ-ID, DATA-MART-USER5
IASTYLEDEFSTYNo description in the Lawson data dictionaryDATABASE-SPACE1
IATIMETIMNo description in the Lawson data dictionaryUSER-DIM-NAME25
IATIMEMBRIABNo description in the Lawson data dictionaryDIMENSION-NAME, MBR-TIME-TYPE, MEMBER-NAME3
IATIMEPRDIPDNo description in the Lawson data dictionaryUSER-DIM-NAME, YEAR, PERIOD-NBR8
IATIMEWEEKIWKNo description in the Lawson data dictionaryUSER-DIM-NAME, YEAR, WEEK-NBR7
IATIMEYRIYRNo description in the Lawson data dictionaryUSER-DIM-NAME, YEAR5
IAXMLFILESXFLNo description in the Lawson data dictionaryXML-USER-NAME, XML-JOB-NAME, XML-DOC-TYPE, XML-FILE-NAME4
IAYEARIAYNo description in the Lawson data dictionaryUSER-DIM-NAME5
IAYEARVARIYVNo description in the Lawson data dictionaryUSER-DIM-NAME, MEMBER-NAME6
IAYEARYRIYYNo description in the Lawson data dictionaryUSER-DIM-NAME, YEAR3
MBRATTRIBMATNo description in the Lawson data dictionaryDIM-OBJ-ID, ATTRIBUTE-NAME, ATTRIB-VALUE5
MBRAUDITMBAMember AuditDATA-MART-NAME, DIM-OBJ-ID5
MBROPTIONSMBOMember OptionsMBR-OBJ-ID, RECORD-TYPE, ALIAS-TABLE, INSTANCE-NAME8
MBRSHARESMBSNo description in the Lawson data dictionaryMBR-OBJ-ID, PARENT-OBJ-ID6
MEMBERMBROutline MembersOBJ-ID13
OLAPDBMODBData Mart ManagerDATA-MART-NAME41
OLAPDIMOLDData Mart DimensionsDATA-MART-NAME, USER-DIM-NAME24
OLAPPROFOLPData Mart ProfilesDATA-MART-NAME, DATA-MART-GRP, PROFILE-NAME15
OLAPUDAUDAMember User-defined AttributesDATA-MART-NAME, UDA-NAME2
PROFDATRELPFLProfile Data SourceDATA-MART-NAME, PROFILE-NAME, DATA-LOAD-NAME3
PROFDIMRELPDRNo description in the Lawson data dictionaryDATA-MART-NAME, DATA-MART-GRP, PROFILE-NAME, USER-DIM-NAME4
ROLAPDBSDBSNo description in the Lawson data dictionaryDATABASE-SPACE23
ROLAPDIMROLNo description in the Lawson data dictionaryUSER-DIM-NAME26
ROLAPIDSRIDNo description in the Lawson data dictionaryDIM-OBJ-ID, META-ID12

Online screens (63)

ScreenDescriptionUpdatesReferences
IA00.1OLAP Destination Definition13
IA00.6OLAP Destination Update32
IA01.1Data Mart Types11
IA01.3Data Mart Types - Single Entry11
IA02.1Dimension Definition15
IA02.2Dimension Type Definition01
IA03.1Data Mart Group21
IA03.2Define Data Mart Group20
IA04.1Member Definition22
IA04.2Member Maintenance22
IA05.1Essbase Parameters21
IA05.2Essbase Server Test02
IA05.3Star Schema Parameters11
IA08.1Locale and Alias Table Mapping12
IA10.1Data Mart Manager114
IA10.2Data Mart Delete111
IA11.1Information Transfer Profiles23
IA11.2Staging Application Name10
IA11.3Olap Database Profiles23
IA12.1Member UDA22
IA12.2Member Alias13
IA12.3Alias Table22
IA13.1Data Load Sources13
IA14.1Dimension Member Override13
IA15.1Dimension Settings62
IA15.4Olap Database Dimensions31
IA16.1Profile Data Sources13
IA20.1Data Mart Security11
IA20.2Data Mart Users11
IA80.1Time Dimension Definition42
IA80.5Period Adjustment11
IA80.6Period End date Adjustment11
IA80.8Week Adjustment11
IA80.9Year Adjustment31
IA85.1Year Definition22
IA85.2Year Definition11
IA85.3Year Variances12
IA90.1Asp Client Definition23
IA90.2ASP Customer Groups11
IA90.3ASP Customer Users20
IA90.4ASP Customer Users22
IA99.1XML Essbase Load05
IAAH.1Olap Database Profiles02
IAAP.1Dimension Definition Interface106
IADE.1Shared Dimension03
IADM.1Invoked Dimension Type11
IAFM.1Data Source Fix Member01
IALL.1Retreive Lawson Locales01
IAMB.1Lawson Member List Update123
IAMD.1Delete Member Information23
IAMR.1Member Information Update03
IANM.1Level Name Alterations34
IAPF.1Information Transfer Profiles05
IARP.1Request Period Detail02
IART.1Request Time Parameters03
IASD.1Simple Data Mart Drill Around07
IASV.1Service Bureau Data Marts80
IASV.2Olap Database Delete111
IATB.1Time Dimension Member Name Build14
IATM.1Olap Dimension Retrieval Format76
IATS.1Simple Data Mart Drill Around04
IAVO.1Olap Dimension Retrieval Format84
IAYR.1Olap Dimension Retrieval Format75

Batch programs (9)

ProgramDescriptionUpdatesReferences
IA100Analytic Architect Startup71
IA115Alias Name Import or Export34
IA120Data Mart Load1612
IA125Provider Site Data Mart Update13
IA150XML Data Mart Interface1113
IA151This program has been retired.10
IA199Customer Data Mart Update13
IA200Unix ESSCMD Interface14
IA300Delete Members56

Other tables used by Analytic Architect programs (5)

APVENMAST, EBCSVREC, POIAATRIB, POIAVNDDIM, WFSETUP