IACUSTMART

REFERENCED BY
IA199 IA99.1


UPDATED BY
IA90.4

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IUM-ASP-CUSTOMER
Element: Asp Customer
Numeric 9
IA90.4
IUM-DATA-MART-NAME
Element: Data Mart Name
Alpha 20 (Lower Case)
This field contains the name of the data mart.
IA90.4
IUM-DATABASE-TYPE
Element: Database Type
Alpha 1

E = Essbase
S = Microsoft Analysis Services
IA90.4
IUM-SERVER-NAME
Element: Server Name
Alpha 40 (Lower Case)
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).
IA90.4
IUM-APPLIC-NAME
Element: Applic Name
Alpha 8 (Lower Case)
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.
IA90.4
IUM-DATABASE-NAME
Element: Database Name
Alpha 8 (Lower Case)
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.
IA90.4
IUM-AUTHENTICATE
Element: Authenticate
Numeric 14
IUM-ACTIVE-STATUS
Element: Active Status
Alpha 1
The status of the account. If Inactive, no posting can be done to the account.
IA90.4
IUM-LOGIN
Element: Login
Alpha 30 (Lower Case)
IA90.4
IUM-PROCESSING
Element: Processing
Alpha 1
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
Element: Job Name
Alpha 10


IACUSTMART FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IUMSET1 ASP-CUSTOMER
DATA-MART-NAME
KeyChange
IA199 IA90.1
IA90.4 IA99.1
IUMSET2 DATABASE-TYPE
SERVER-NAME
APPLIC-NAME
DATABASE-NAME
KeyChange, Subset
WhereDATABASE-TYPE ="E"
IA90.4
IUMSET3 LOGIN
ASP-CUSTOMER
DATA-MART-NAME
KeyChange


IACUSTMART FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Iacustomer IACUSTOMER Required
IUM-ASP-CUSTOMER->ICE-ASP-CUSTOMER (ICESET1)
Iacustusrs IACUSTUSRS Required
IUM-LOGIN->IUU-LOGIN


File created: Thu Jun 09 02:18:01 2016

Home
Contact Us



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