WOIADIM FILE
WO Data Mart Definition
REFERENCED BY
WODL.1 WOME.1 WOOR.1 WOSC.1
UPDATED BY
WODM.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WOA-DATA-MART-NAME Alpha 20 (Lower Case) WODM.1
Element: Data Mart Name
WOA-TIME-DIM Alpha 50 (Lower Case) WODM.1
Element: Time Dim
WOA-YEAR-DIM Alpha 50 (Lower Case) WODM.1
Element: Year Dim
WOA-MEASURE-DIM Alpha 50 (Lower Case) WODM.1
Element: Measure Dim
WOA-SCENERIO-DIM Alpha 50 (Lower Case) WODM.1
Element: Scenerio Dim
WOA-ORG-DIM Alpha 50 (Lower Case) WODM.1
Element: Org Dim
WOA-PRODUCT-DIM Alpha 50 (Lower Case) WODM.1
Element: Product Dim
WOA-DATA-LOAD-OPT Alpha 1 WODM.1
Element: Data Load Opt The Data Values Load Option field
specifies how the data values are loaded
into the data mart.
Value values are:
N = No Load
I = Incremental
C = Complete; Default value.
A = Load All Data
P = Partial Data Load
WOA-DATALD-BEG-PER Numeric 2 WODM.1
Element: Datald Beg Per
WOA-DATALD-BEG-YR Numeric 4 WODM.1
Element: Datald Beg Yr
WOA-DATALD-END-PER Numeric 2 WODM.1
Element: Datald End Per
WOA-DATALD-END-YR Numeric 4 WODM.1
Element: Datald End Yr
WOA-MAINT-DATE Numeric 8 (yyyymmdd) WODM.1
Element: Date
WOA-MAINT-TIME Numeric 6 (hhmmss) WODM.1
Element: Sys Time
WOIADIM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WOASET1 DATA-MART-NAME WODL.1 WODM.1
WOME.1 WOOR.1
WOSC.1
|
