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 |
IA10.1 | IA10.2 | IA14.1 | IA15.1 | IASV.2 |
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
DDR-META-ID Element: Meta Id | Numeric 9 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
DDRSET1 |
DATA-MART-NAME USER-DIM-NAME DATA-LOAD-NAME |
|
| ||||||||||||
DDRSET2 |
DATA-MART-NAME DATA-LOAD-NAME USER-DIM-NAME |
|
|
All trademarks and registered trademarks are the property of their
respective owners.