IASECURITY FILE
REFERENCED BY
IA10.1 IA120 IA150 IA02.1
UPDATED BY
IA20.2 IAAP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IAS-SECURITY-TYPE Alpha 1 IA20.2
Security Type 1 = Data Mart Security
2 = Dimension Security
3 = Administrators
IAS-DIM-OBJ-ID Numeric 12
Dim Obj Id The Dimension Object Identifier field
contains a unique numeric identifier
assigned to the dimension, which
associates this record to the member
records.
IAS-USER-DIM-NAME Alpha 50 (Lower Case)
User Dim Name The User Dimension Name is the name
associated with the dimension in the
data mart outline. This user-defined
name can contain up to 50 alphanumeric
characters. For example, you might name
a dimension Fiscal Year or Organization.
IAS-DATA-MART-NAME Alpha 20 (Lower Case) IA20.2
Data Mart Name
IAS-DATA-MART-USER Alpha 20 (Lower Case) IA20.2
Data Mart User
IASECURITY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IASSET1 SECURITY-TYPE KeyChange
DATA-MART-NAME
DIM-OBJ-ID
DATA-MART-USER
IASSET2 DATA-MART-NAMEKeyChange, Subset IA10.1 IA120
DATA-MART-USERWhere SECURITY-TYPE = "1" IA150 IA20.1
IA20.2
IASSET3 DIM-OBJ-ID KeyChange, Subset IA02.1 IAAP.1
DATA-MART-USERWhere SECURITY-TYPE = "2"
IASSET4 USER-DIM-NAME KeyChange, Subset
Where SECURITY-TYPE = "3"
|
