ALIASTABLE – Alias Table
- System
- Analytic Architect (IA)
- Prefix
ALI- Primary key
DATA-MART-NAME,ALIAS-TABLE- Fields
- 4
- Updated by
- 6 programs
- Referenced by
- 3 programs
ALIASTABLE is the Alias Table table in Lawson Analytic Architect (prefix ALI). It is indexed by DATA-MART-NAME, ALIAS-TABLE (ALISET1). It is updated by IA10.1, IA10.2, IA115, IA12.3, IASV.1 and IASV.2 and referenced by IA08.1, IA120 and IASD.1. The table has 4 fields, 1 index and 0 documented relations.
About ALIASTABLE
The Alias Table (ALIASTABLE) file stores the definition for each alias table. All member alias names must be associated with an alias table. Using multiple alias tables allows a member to have a unique alias name. The information in this file comes from IA12.3 (Alias Table).
Fields (4)
Column = COBOL field name without the ALI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ALI-DATA-MART-NAME PKDATA_MART_NAME | Alpha 20 (Lower Case) | This field contains the name of the data mart. | IA10.1, IA115, IA12.3, IASV.1 |
ALI-ALIAS-TABLE PKALIAS_TABLE | Alpha 8 (Lower Case) | The Alias Table field contains the name of the table that contains member alias names. You use the Essbase Application Manager to define alias tables. You can use the Analytic Architect system to define an alias name to associate with a member. These alias names become part of the alias table. The alias table must be defined for a specific application and data mart. This field can be left blank. All member aliases applied to the blank alias table name are associated to the default alias table defined by the data mart. | IA10.1, IA115, IA12.3, IASV.1 |
ALI-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | The Description field contains a description of the alias table. | IA10.1, IA115, IA12.3, IASV.1 |
ALI-UPDATED-FLAGUPDATED_FLAG | Alpha 1 | —
| IA10.1, IA10.2, IA115, IA12.3, IASV.1, IASV.2 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ALISET1 | DATA-MART-NAME, ALIAS-TABLE | Primary, KeyChange | IA08.1, IA10.1, IA10.2, IA115, IA12.2, IA12.3, IA120, IASD.1 +2 more |
Programs
Updated by (6)
- IA10.1 Data Mart Manager
- IA10.2 Data Mart Delete
- IA115 Alias Name Import or Export
- IA12.3 Alias Table
- IASV.1 Service Bureau Data Marts
- IASV.2 Olap Database Delete