IACUSTMART FILE
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IUM-ASP-CUSTOMER Numeric 9
Asp Customer
IUM-DATA-MART-NAME Alpha 20 (Lower Case)
Data Mart Name
IUM-DATABASE-TYPE Alpha 1
Database Type E = Essbase
S = Microsoft Analysis Services
IUM-SERVER-NAME Alpha 40 (Lower Case)
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)
Application Name The 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)
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
Authenticate
IUM-ACTIVE-STATUS Alpha 1
Status The status of the account. If Inactive,
no posting can be done to the account.
IUM-LOGIN Alpha 30 (Lower Case)
Login
IUM-PROCESSING Alpha 1
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
Job Name
IACUSTMART FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IUMSET1 ASP-CUSTOMER KeyChange
DATA-MART-NAME
IUMSET2 DATABASE-TYPE KeyChange, Subset
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
|
