DIMDATAREL

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).
UPDATED BY
IA10.1 IA10.2 IA14.1 IA15.1 IASV.2 IAFM.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DDR-DATA-MART-NAME
Element: Data Mart Name
Alpha 20 (Lower Case)
This field contains the name of the data mart.
IA14.1
DDR-USER-DIM-NAME
Element: User Dim Name
Alpha 50 (Lower Case)
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.
IA14.1
DDR-DATA-LOAD-NAME
Element: Data Load Name
Alpha 12 (Lower Case)
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.
IA14.1
DDR-MEMBER-NAME
Element: Member Name
Alpha 50 (Lower Case)
This is an override member name for Data Mart dimensions with no association to a Budget dimension.
IA14.1
DDR-META-ID
Element: Meta Id
Numeric 9


DIMDATAREL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DDRSET1 DATA-MART-NAME
USER-DIM-NAME
DATA-LOAD-NAME
KeyChange
IA10.1 IA10.2
IA14.1 IA15.1
IASV.2
DDRSET2 DATA-MART-NAME
DATA-LOAD-NAME
USER-DIM-NAME
KeyChange
IAFM.1


File created: Wed Jun 08 20:49:32 2016

Home
Contact Us



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