|
|
IACUSTMART FILE
REFERENCED BY
IA199 IA99.1
UPDATED BY
IA90.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IUM-ASP-CUSTOMER Numeric 9 IA90.4
Element: Asp Customer
IUM-DATA-MART-NAME Alpha 20 (Lower Case) IA90.4
Element: Data Mart NameThis field contains the name of the data
mart.
IUM-DATABASE-TYPE Alpha 1 IA90.4
Element: Database Type E = Essbase
S = Microsoft Analysis Services
IUM-SERVER-NAME Alpha 40 (Lower Case) IA90.4
Element: Server Name The Server Name field contains the IP
address of the server to which you are
connecting. You can also specify a name
that has been associated with the server
(DNS name).
IUM-APPLIC-NAME Alpha 8 (Lower Case) IA90.4
Element: Application NaThe Application Name is the name of the
application that describes the database
names it contains. This user-defined
name can contain up to eight characters.
The first letter of the name must be
capitalized.
IUM-DATABASE-NAME Alpha 8 (Lower Case) IA90.4
Element: Database Name The Database Name is the name of the
database that is stored within the OLAP
application. Each application may
contain more than one database. This
user-defined name can contain up to
eight characters. The first letter of
the name must be capitalized.
IUM-AUTHENTICATE Numeric 14
Element: Authenticate
IUM-ACTIVE-STATUS Alpha 1 IA90.4
Element: Status The status of the account. If Inactive,
no posting can be done to the account.
IUM-LOGIN Alpha 30 (Lower Case) IA90.4
Element: Login
IUM-PROCESSING Alpha 1
Element: Processing The Processing field shows the current
status of the data mart. It provides a
locking mechanism to prevent updates
when data is being loaded to the data
mart.
Value values are:
~ = No data is being processed
M = Outline build in process
D = Data load in process
C = Data mart calculation in process
IUM-JOB-NAME Alpha 10
Element: Job Name
IACUSTMART FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IUMSET1 ASP-CUSTOMER KeyChange IA199 IA90.1
DATA-MART-NAME IA90.4 IA99.1
IUMSET2 DATABASE-TYPE KeyChange, Subset IA90.4
SERVER-NAME Where DATABASE-TYPE = "E"
APPLIC-NAME
DATABASE-NAME
IUMSET3 LOGIN KeyChange
ASP-CUSTOMER
DATA-MART-NAME
IACUSTMART FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iacustomer IACUSTOMER Required
IUM-ASP-CUSTOMER -> ICE-ASP-CUSTOMER (ICESET1)
Iacustusrs IACUSTUSRS Required
IUM-LOGIN -> IUU-LOGIN
|
