IALOCALES – Locales
- System
- Analytic Architect (IA)
- Prefix
IAL- Primary key
DATA-MART-NAME,ALIAS-TABLE- Fields
- 3
- Updated by
- 3 programs
- Referenced by
- 1 program
IALOCALES is the Locales table in Lawson Analytic Architect (prefix IAL). It is indexed by DATA-MART-NAME, ALIAS-TABLE (IALSET1); alternate indexes: IALSET2. It is updated by IA08.1, IA10.2 and IASV.2 and referenced by IALL.1. The table has 3 fields, 2 indexes and 0 documented relations.
About IALOCALES
The Locales (IALOCALE) file contains the environment locale and the alias table that have been linked for translation purposes. The information in this file comes from IA08.1 (Locale and Alias Table Mapping).
Fields (3)
Column = COBOL field name without the IAL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
IAL-DATA-MART-NAME PKDATA_MART_NAME | Alpha 20 (Lower Case) | This field contains the name of the data mart. | IA08.1 |
IAL-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. | IA08.1 |
IAL-LOCALELOCALE | Alpha 10 (Lower Case) | The Locale field contains the Environment locale that has been mapped to the alias table specified in the Alias Table field. If a match exists translation values defined for a specific locale are substituted for alias names within the alias table. | IA08.1 |
Indexes (2)
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 |
|---|---|---|---|---|
IALSET1 | DATA-MART-NAME, ALIAS-TABLE | Primary, KeyChange | IA08.1, IA10.2, IASV.2 | |
IALSET2 | DATA-MART-NAME, LOCALE | IA08.1, IALL.1 |
Programs
Updated by (3)
Referenced by (1)
- IALL.1 Retreive Lawson Locales