IA120 – Data Mart Load
- System
- Analytic Architect (IA)
- Type
- Batch program
- Updates
- 16 tables
- References
- 12 tables
IA120 (Data Mart Load) is a Lawson Analytic Architect batch program. It updates CKPOINT, DATASOURCE, EBCSVREC, IACALCMBR, IADIMDLT, IADRILL, IAFILEDEF, IAFILEDLT and 8 more and references ALIASTABLE, APPLICTYPE, IAATTRIB, IADIMDLT, IAFORMULA, IASECURITY, MBRATTRIB, MBROPTIONS and 4 more.
About IA120
Run Data Mart Load (IA120) to define the parameters that are required for building the outline and loading data into the Essbase data mart. **Process at a Glance 1. Load the preassigned data mart types. 2. Create an OLAP destination. 3. Define the data mart. 4. Define the dimensions for the data mart. 5. Define the information transfer profile. 6. (YOU ARE HERE) Load the data mart.
Updated files (16)
| Table | Description | System |
|---|---|---|
| CKPOINT | No description in the Lawson data dictionary | — |
| DATASOURCE | Data Source | IA |
| EBCSVREC | No description in the Lawson data dictionary | EB |
| IACALCMBR | No description in the Lawson data dictionary | IA |
| IADIMDLT | No description in the Lawson data dictionary | IA |
| IADRILL | No description in the Lawson data dictionary | IA |
| IAFILEDEF | No description in the Lawson data dictionary | IA |
| IAFILEDLT | No description in the Lawson data dictionary | IA |
| MBRAUDIT | Member Audit | IA |
| MBROPTIONS | Member Options | IA |
| MBRSHARES | No description in the Lawson data dictionary | IA |
| MEMBER | Outline Members | IA |
| OLAPDBM | Data Mart Manager | IA |
| OLAPDIM | Data Mart Dimensions | IA |
| ROLAPDIM | No description in the Lawson data dictionary | IA |
| ROLAPIDS | No description in the Lawson data dictionary | IA |
Referenced files (12)
| Table | Description | System |
|---|---|---|
| ALIASTABLE | Alias Table | IA |
| APPLICTYPE | Application Type | IA |
| IAATTRIB | No description in the Lawson data dictionary | IA |
| IADIMDLT | No description in the Lawson data dictionary | IA |
| IAFORMULA | No description in the Lawson data dictionary | IA |
| IASECURITY | No description in the Lawson data dictionary | IA |
| MBRATTRIB | No description in the Lawson data dictionary | IA |
| MBROPTIONS | Member Options | IA |
| OLAPPROF | Data Mart Profiles | IA |
| PROFDATREL | Profile Data Source | IA |
| ROLAPDBS | No description in the Lawson data dictionary | IA |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (8)
IAAH, IADT, IAED, IALL, IAMB, IAMR, IARF, IFOB