ALIASTABLE

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


UPDATED BY
IA10.1 IA10.2 IA115 IA12.3 IA12.2 IASV.1
IASV.2 IA120 IASD.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ALI-DATA-MART-NAME
Element: Data 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
Element: Alias Table Name
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-DESCRIPTION
Alias Table
Description
Alpha 30 (Lower Case)
The Description field contains a description of the alias table.
IA10.1 IA115
IA12.3 IASV.1
ALI-UPDATED-FLAG
Element: Alias Table Status
Alpha 1

N = Not Updated
U = Updated
IA10.1 IA10.2
IA115 IA12.3
IASV.1 IASV.2


ALIASTABLE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ALISET1 DATA-MART-NAME
ALIAS-TABLE
KeyChange
IA08.1 IA10.1
IA10.2 IA115
IA12.2 IA12.3
IA120 IASD.1
IASV.1 IASV.2


File created: Wed Jun 08 20:49:32 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.