DIMDATAREL – Dimension Data Source
- System
- Analytic Architect (IA)
- Prefix
DDR- Primary key
DATA-MART-NAME,USER-DIM-NAME,DATA-LOAD-NAME- Fields
- 5
- Updated by
- 5 programs
- Referenced by
- 1 program
DIMDATAREL is the Dimension Data Source table in Lawson Analytic Architect (prefix DDR). It is indexed by DATA-MART-NAME, USER-DIM-NAME, DATA-LOAD-NAME (DDRSET1); alternate indexes: DDRSET2. It is updated by IA10.1, IA10.2, IA14.1, IA15.1 and IASV.2 and referenced by IAFM.1. The table has 5 fields, 2 indexes and 0 documented relations.
About DIMDATAREL
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).
Fields (5)
Column = COBOL field name without the DDR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
DDR-DATA-MART-NAME PKDATA_MART_NAME | Alpha 20 (Lower Case) | This field contains the name of the data mart. | IA14.1 |
DDR-USER-DIM-NAME PKUSER_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 PKDATA_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-NAMEMEMBER_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-IDMETA_ID | Numeric 9 | — | — |
Indexes (2)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
DDRSET1 | DATA-MART-NAME, USER-DIM-NAME, DATA-LOAD-NAME | Primary, KeyChange | IA10.1, IA10.2, IA14.1, IA15.1, IASV.2 | |
DDRSET2 | DATA-MART-NAME, DATA-LOAD-NAME, USER-DIM-NAME | KeyChange | IAFM.1 |
Programs
Updated by (5)
- IA10.1 Data Mart Manager
- IA10.2 Data Mart Delete
- IA14.1 Dimension Member Override
- IA15.1 Dimension Settings
- IASV.2 Olap Database Delete
Referenced by (1)
- IAFM.1 Data Source Fix Member