Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ALIASTABLE


                            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
Element: Data Mart NameThis field contains the name of the data  IA12.3  IASV.1
                       mart.

ALI-ALIAS-TABLE        Alpha 8  (Lower Case)                     IA10.1  IA115
Element: Alias Table NaThe 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
Element: Alias Table St                                          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