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
|