Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            ALIASTABLE FILE

                              Alias Table

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).

REFERENCED BY

IA08.1    IA120     IASD.1

UPDATED BY

IA10.1    IA10.2    IA115     IA12.3    IASV.1    IASV.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ALI-DATA-MART-NAME   Alpha 20  (Lower Case)                      IA10.1  IA115
Data Mart Name                                                   IA12.3  IASV.1

ALI-ALIAS-TABLE      Alpha 8  (Lower Case)                       IA10.1  IA115
Alias Table Name     The Alias Table field contains the name     IA12.3  IASV.1
                     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.

ALI-DESCRIPTION      Alpha 30  (Lower Case)                      IA10.1  IA115
Alias Table          The Description field contains a            IA12.3  IASV.1
Description          description of the alias table.

ALI-UPDATED-FLAG     Alpha 1                                     IA10.1  IA10.2
Alias Table Status                                               IA115   IA12.3
                     N = Not Updated                             IASV.1  IASV.2
                     U = Updated

                         ALIASTABLE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ALISET1   DATA-MART-NAMEKeyChange                                IA08.1  IA10.1
          ALIAS-TABLE                                            IA10.2  IA115
                                                                 IA12.2  IA12.3
                                                                 IA120   IASD.1
                                                                 IASV.1  IASV.2