Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            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