DIMDATAREL FILE
Dimension Data Source
The Dimension Data Source Relationship (DIMDATAREL) file contains the member
name that is used for the specified dimension and data source. This member
name is independent of the data source. The information in this file comes
from IA14.1 (Dimension Member Overrides).
REFERENCED BY
IAFM.1
UPDATED BY
IA10.1 IA10.2 IA14.1 IA15.1 IASV.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DDR-DATA-MART-NAME Alpha 20 (Lower Case) IA14.1
Data Mart Name
DDR-USER-DIM-NAME Alpha 50 (Lower Case) IA14.1
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.
DDR-DATA-LOAD-NAME Alpha 12 (Lower Case) IA14.1
Data Load Name The Data Source Name field contains the
unique name for the source containing
the data values you are loading. You can
define multiple data sources for a
single data mart. Examples of data
sources are programs or rules files.
This user-defined name can contain up to
12 characters of any kind.
DDR-MEMBER-NAME Alpha 50 (Lower Case) IA14.1
Member Name This is an override member name for
Data Mart dimensions with no association
to a Budget dimension.
DDR-META-ID Numeric 9
Meta Id
DIMDATAREL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DDRSET1 DATA-MART-NAMEKeyChange IA10.1 IA10.2
USER-DIM-NAME IA14.1 IA15.1
DATA-LOAD-NAME IASV.2
DDRSET2 DATA-MART-NAMEKeyChange IAFM.1
DATA-LOAD-NAME
USER-DIM-NAME
|
